SRAVAN ORACLE APPS HRMS

Query: Organization Manager

select org_tl.name "Organization", ppf.full_name ...
Oracle HRMS Tables

Oracle HRMS Tables Oracle HRMS Table Name Table Description HR_ALL_ORGANIZATION_UNITS Organization...
Oracle Learning Management – OLM Tables

In Oracle HRMS Overview Series of Articles, This is the first to one to talk technical aspects of OLM (Oracle Learning Management). In this...
Terminate Employee Oracle EBS (Calling API)

Employee data could be terminated from back end using oracle HRMS API (HR_EX_EMPLOYEE_API.ACTUAL_TERMINATION_EMP). Declare CURSOR c_emp_...
Basic Payroll Tables and their links

SELECT * FROM PAY_ELEMENT_TYPES_F(PK: ELEMENT_TYPE_ID) SELECT * FROM PAY_ELEMENT_LINKS_F(PK: ELEMENT_LINK_ID) ...
To delete pending leaves

To delete pending leaves As far as i know there is no API to delete pending leaves. Solution1: This is my own way of deleting the leave...
Query: Grade Rates

select pr.name "Rate", -- pgt.name "Grade Name", fcv....
Query: Contracts

select per.employee_number "Employee Number", -- p...
Oracle HRMS Query to Get Latest Basic Salary Change Date

SELECT ppps.proposed_salary_n from per_pay_proposals ppps where paaf.assignment_id = ppps.assignment_id AND ppps.last_change_date is n...
Oracle HRMS Query - Absence

SELECT /*+ rule*/ xx.person_id, xx.assignment_id, flv.meaning absence_category, c.NAME absence_type, flv1.mean...