APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PER_ABSENCE_ATTENDANCES

Line 180: from per_absence_attendances ab

176: , ab.date_start
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

Line 1264: from per_absence_attendances ab

1260: and ast.per_system_status <> 'ACTIVE_ASSIGN';
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

Line 2181: FROM per_absence_attendances paa

2177: ,c_end_date IN DATE)
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

Line 2435: FROM per_absence_attendances paa

2431: ,c_end_date IN DATE)
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