DBA Data[Home] [Help]

APPS.HR_NZ_HOLIDAYS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 1437: , per_absence_attendance_types aat

1433: cursor c_number_of_leave_weeks(p_assignment_id number
1434: ,p_start_of_year date) is
1435: select nvl(sum(ab.abs_information2), 0) number_of_complete_weeks
1436: from per_absence_attendances ab
1437: , per_absence_attendance_types aat
1438: , pay_element_entries_f ee
1439: , pay_run_results rr
1440: , pay_assignment_actions aa
1441: , pay_payroll_actions pa

Line 1677: per_absence_attendance_types paat

1673: ,c_start_date IN DATE
1674: ,c_end_date IN DATE)IS
1675: select 1
1676: from per_absence_attendances paa,
1677: per_absence_attendance_types paat
1678: where paa.person_id = (select distinct person_id
1679: from per_assignments_f paaf
1680: where paaf.assignment_id = c_assignment_id)
1681: and paa.business_group_id = c_business_group_id