eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PER_ABSENCE_ATTENDANCES

Line 66: ,per_absence_attendances paa

62: ,paa.abs_information6
63: ,paa.abs_information7
64: ,paa.abs_information8
65: FROM per_abs_attendance_reasons paar
66: ,per_absence_attendances paa
67: ,per_absence_attendance_types paat
68: WHERE paa.absence_attendance_id = p_absence_attendance_id
69: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id
70: AND paa.abs_attendance_reason_id = paar.abs_attendance_reason_id (+);

Line 196: FROM per_absence_attendances paa

192: ,p_disability_start_date DATE) IS
193: SELECT paa.date_start start_date
194: ,paa.date_end end_date
195: ,paa.abs_information1 linked_absence
196: FROM per_absence_attendances paa
197: WHERE paa.absence_attendance_id = l_absence_attendance_id
198: AND paa.date_start > ADD_MONTHS(p_disability_start_date,-6);
199: --
200: l_Days NUMBER;

Line 203: l_Linked_Absence per_absence_attendances.abs_information1%TYPE;

199: --
200: l_Days NUMBER;
201: l_Start_Date DATE;
202: l_End_Date DATE;
203: l_Linked_Absence per_absence_attendances.abs_information1%TYPE;
204: l_absence_attendance_id per_absence_attendances.absence_attendance_id%TYPE;
205: --
206: BEGIN
207: --

Line 204: l_absence_attendance_id per_absence_attendances.absence_attendance_id%TYPE;

200: l_Days NUMBER;
201: l_Start_Date DATE;
202: l_End_Date DATE;
203: l_Linked_Absence per_absence_attendances.abs_information1%TYPE;
204: l_absence_attendance_id per_absence_attendances.absence_attendance_id%TYPE;
205: --
206: BEGIN
207: --
208: l_Days := 0;

Line 462: FROM per_absence_attendances PAA1

458: CURSOR csr_abs_details(p_absence_attendance_id NUMBER) IS
459: SELECT NVL(PAA1.date_end,to_date('31-12-4712','dd-mm-yyyy'))-PAA1.date_start+1
460: ,PAAT1.absence_category Reason_Category_prev
461: ,PAAT2.absence_category Reason_Category
462: FROM per_absence_attendances PAA1
463: ,per_absence_attendances PAA2
464: ,per_absence_attendance_types PAAT1
465: ,per_absence_attendance_types PAAT2
466: WHERE PAA2.absence_attendance_id = p_absence_attendance_id

Line 463: ,per_absence_attendances PAA2

459: SELECT NVL(PAA1.date_end,to_date('31-12-4712','dd-mm-yyyy'))-PAA1.date_start+1
460: ,PAAT1.absence_category Reason_Category_prev
461: ,PAAT2.absence_category Reason_Category
462: FROM per_absence_attendances PAA1
463: ,per_absence_attendances PAA2
464: ,per_absence_attendance_types PAAT1
465: ,per_absence_attendance_types PAAT2
466: WHERE PAA2.absence_attendance_id = p_absence_attendance_id
467: AND PAA2.date_start = PAA1.date_end + 1