APPS.PAY_FR_SICKNESS_CALC dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 857: per_absence_attendance_types pabt

853: -- Cursor for finding holidays within the date range
854: Cursor csr_holidays(c_hol_date varchar2, c_person_id Number) IS
855: SELECT count(*)
856: FROM per_absence_attendances pabs_hol,
857: per_absence_attendance_types pabt
858: WHERE pabs_hol.person_id = c_person_id
859: AND pabs_hol.business_group_id = p_business_group_id
860: AND c_hol_date BETWEEN pabs_hol.date_start AND pabs_hol.date_end
861: AND pabt.absence_attendance_type_id = pabs_hol.absence_attendance_type_id

Line 868: per_absence_attendance_types pabt

864: -- check if a maternity absence exists within 48 hours of this sickness
865: Cursor csr_maternity(c_sick_start_date date, c_person_id Number) IS
866: SELECT nvl(min('Y'),'N') maternity_related
867: FROM per_absence_attendances pabs,
868: per_absence_attendance_types pabt
869: WHERE pabs.person_id = c_person_id
870: AND (c_sick_start_date - 3 ) BETWEEN pabs.date_start AND pabs.date_end
871: AND pabt.absence_attendance_type_id = pabs.absence_attendance_type_id
872: AND pabt.absence_category = 'M';

Line 1566: per_absence_attendance_types pabt

1562: -- check if a maternity absence exists within 48 hours of this sickness
1563: Cursor csr_maternity(c_sick_start_date date, c_person_id Number) IS
1564: SELECT nvl(min('Y'),'N') maternity_related
1565: FROM per_absence_attendances pabs,
1566: per_absence_attendance_types pabt
1567: WHERE pabs.person_id = c_person_id
1568: AND (c_sick_start_date - 3 ) BETWEEN pabs.date_start AND pabs.date_end
1569: AND pabt.absence_attendance_type_id = pabs.absence_attendance_type_id
1570: AND pabt.absence_category = 'M';

Line 4078: per_absence_attendance_types pabt,

4074: , nvl(pabs.abs_information8, 'N') estimated
4075: , nvl(pwi.inc_information1,'N') work_incident
4076: from per_absence_attendances pabs,
4077: per_all_assignments_f pasg,
4078: per_absence_attendance_types pabt,
4079: per_work_incidents pwi
4080: where pabs.business_group_id = p_business_group_id
4081: and pabs.abs_information_category ='FR_S'
4082: and pabs.date_start <= p_payment_start_date

Line 4304: per_absence_attendance_types pabt,

4300: -- Cursor for finding holidays within the date range
4301: Cursor csr_holidays(c_hol_date varchar2) IS
4302: SELECT 'H'
4303: FROM per_absence_attendances pabs_hol,
4304: per_absence_attendance_types pabt,
4305: per_absence_attendances pabs_sick
4306: WHERE pabs_sick.absence_attendance_id = p_absence_id
4307: AND pabs_sick.business_group_id = p_business_group_id
4308: AND pabs_hol.person_id = pabs_sick.person_id