APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 67: ,per_absence_attendance_types paat

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 (+);
71: --

Line 464: ,per_absence_attendance_types PAAT1

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
468: AND PAA1.person_id = PAA2.person_id

Line 465: ,per_absence_attendance_types PAAT2

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
468: AND PAA1.person_id = PAA2.person_id
469: AND PAA1.absence_attendance_type_id = PAAT1.absence_attendance_type_id

Line 472: l_category per_absence_attendance_types.absence_category%TYPE;

468: AND PAA1.person_id = PAA2.person_id
469: AND PAA1.absence_attendance_type_id = PAAT1.absence_attendance_type_id
470: AND PAA2.absence_attendance_type_id = PAAT2.absence_attendance_type_id;
471: --
472: l_category per_absence_attendance_types.absence_category%TYPE;
473: l_category_prev per_absence_attendance_types.absence_category%TYPE;
474: --
475: BEGIN
476: --

Line 473: l_category_prev per_absence_attendance_types.absence_category%TYPE;

469: AND PAA1.absence_attendance_type_id = PAAT1.absence_attendance_type_id
470: AND PAA2.absence_attendance_type_id = PAAT2.absence_attendance_type_id;
471: --
472: l_category per_absence_attendance_types.absence_category%TYPE;
473: l_category_prev per_absence_attendance_types.absence_category%TYPE;
474: --
475: BEGIN
476: --
477: l_category := 'x';