Discussion in 'Oracle HRMS & Payroll' started by Bhavani, Nov 11, 2009.
Please give me the step by step Oracle HRMS Navigation setup as I'm very new to ORacle Apps
Have you seen the User Manual? Tutor docs? Searched Metalink? Searched this site?
Hi I need
the employee number, organization name under primary assignment,
organization name under secondary assignment and associate effective
date and end date. Again, I need a sql to generate these data
Below is the query to retrieve the Organization for employees.
SELECT PAPF.EMPLOYEE_NUMBER "Employee Number"
, HAOU.NAME "Organization"
FROM PER_ALL_PEOPLE_F PAPF
, PER_ALL_ASSIGNMENTS_F PAAF,
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PAPF.FULL_NAME = 'ABC, DEF'
AND TRUNC(SYSDATE) BETWEEN TRUNC(PAPF.EFFECTIVE_START_DATE) AND TRUNC(PAPF.EFFECTIVE_END_DATE)
AND PAAF.PERSON_ID (+) = PAPF.PERSON_ID
AND HAOU.ORGANIZATION_ID (+) = PAAF.ORGANIZATION_ID;
Based on the requirement change the restriction. For example I have suggested full name of the employee as parameter.