APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 181: , per_absence_attendance_types abt

177: , ab.date_end
178: , ((ab.date_end - ab.date_start) - g_unpaid_absence_days) add_days
179: -- however, do not move the initial qualifying period
180: from per_absence_attendances ab
181: , per_absence_attendance_types abt
182: where ab.absence_attendance_type_id = abt.absence_attendance_type_id
183: and ab.person_id = p_person_id
184: and abt.absence_category = g_unpaid_absence_category
185: and ab.date_start between p_start_date and p_end_date

Line 1265: , per_absence_attendance_types abt

1261:
1262: select (ab.date_start + g_unpaid_absence_days + 1), ab.date_end
1263: bulk collect into l_abs_start_date, l_abs_end_date
1264: from per_absence_attendances ab
1265: , per_absence_attendance_types abt
1266: where ab.absence_attendance_type_id = abt.absence_attendance_type_id
1267: and ab.person_id = l_person_id
1268: and abt.absence_category = g_unpaid_absence_category
1269: and ((ab.date_end - ab.date_start) > g_unpaid_absence_days);

Line 2182: ,per_absence_attendance_types paat

2178: IS
2179: --
2180: SELECT 1
2181: FROM per_absence_attendances paa
2182: ,per_absence_attendance_types paat
2183: ,per_assignments_f paf
2184: WHERE paa.person_id = paf.person_id
2185: AND paf.assignment_id = p_assignment_id
2186: AND paa.business_group_id = c_business_group_id

Line 2436: ,per_absence_attendance_types paat

2432: IS
2433: --
2434: SELECT nvl(nvl(sum(absence_days),sum(absence_hours)),0) cnt_abs
2435: FROM per_absence_attendances paa
2436: ,per_absence_attendance_types paat
2437: ,pay_accrual_plans pap
2438: ,per_assignments_f paf
2439: WHERE paa.person_id = paf.person_id
2440: AND paf.assignment_id = c_assignment_id