Oracle APPS HRMS Queries

Oracle Apps HRMS Absence.


SELECT PAPF.PERSON_ID,PAPF.FIRST_NAME ||' ' || PAPF.LAST_NAME AS NAME,PJ.NAME AS JOBS ,PG.NAME AS GRADE ,PAP.NAME AS POSITION,HAOU.NAME AS ORAGNAIZATION, PAAT.NAME AS LEAVE,PAA.DATE_START,PAA.DATE_END,PAA.ABSENCE_DAYS,PAA.TIME_START,PAA.TIME_END,ABSENCE_HOURS
FROM PER_ABSENCE_ATTENDANCES PAA,PER_ABSENCE_ATTENDANCE_TYPES PAAT
,PER_ALL_PEOPLE_F PAPF,HR_ALL_ORGANIZATION_UNITS HAOU,PER_ALL_ASSIGNMENTS_F PASF,PER_JOBS PJ,PER_GRADES PG,
PER_ALL_POSITIONS PAP
WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAAT.ABSENCE_ATTENDANCE_TYPE_ID
AND PAPF.PERSON_ID = PAA.PERSON_ID
AND PASF.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND PASF.LOCATION_ID = HAOU.LOCATION_ID
AND PASF.PERSON_ID = PAPF.PERSON_ID
AND PJ.JOB_ID = PASF.JOB_ID
AND PG.GRADE_ID = PASF.GRADE_ID
AND PAP.POSITION_ID = PASF.POSITION_ID
AND PAPF.EFFECTIVE_END_DATE > SYSDATE
AND PASF.EFFECTIVE_END_DATE > sysdate
ORDER BY 1,4