SRAVAN ORACLE APPS HRMS

No posts with label SSHR Queries. Show all posts

Subscribe to: Posts (Atom)

Labels

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...
Query: Organization Manager

select org_tl.name "Organization", ppf.full_name ...
Query: Grade Rates

select pr.name "Rate", -- pgt.name "Grade Name", fcv....
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_...
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...
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: Contracts

select per.employee_number "Employee Number", -- p...
Query: Grade Scale Rates

select pgtl.name "Grade Name" , -- pps.name "Pay Scale Name", ...
Oracle HRMS Query - Absence

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

DECLARE ln_assignment_id NUMBER; lb_correction VARCHAR2(100); lb_update VARCHAR2(100); lb_update_override ...