[Home] [Help]
1432:
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
1672: ,c_business_group_id IN NUMBER
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)
2081:
2082: -- cursor to get annual leave in advance payments made during the year
2083: --
2084: -- This is a bit complicated: the hours taken come from the absence
2085: -- record (per_absence_attendances). A corresponding element entry,
2086: -- "absence element entry", is created for each absence record
2087: -- (pay_element_entries_f). When the absence element entry gets processed
2088: -- an indirect result causes a new entry to be created for the "Annual
2089: -- Leave Pay" element type. The pay value run result for the "Annual
2101: , pay_element_entry_values_f eev -- absence element entry
2102: -- "hours taken" entry value
2103: , pay_element_entries_f ee -- absence element entry
2104: , pay_run_results rr -- run result for absence -- element entry
2105: , per_absence_attendances ab -- absence record
2106: , pay_assignment_actions aa -- assignment action for -- absence element entry
2107: , pay_payroll_actions pa -- payroll action for -- absence element entry
2108: , per_time_periods tp
2109: , pay_run_results rr2 -- run result for Annual -- Leave Pay element type