[Home] [Help]
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
1442: , per_time_periods tp
1443: where aat.absence_attendance_type_id = ab.absence_attendance_type_id
2100: from pay_accrual_plans ap -- annual leave accrualplan
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
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
2110: , pay_run_result_values rrv2 -- run result value for -- Annual Leave Pay element -- pay value ,
2111: , pay_element_types_f et2 -- Annual Leave Pay element
2112: , pay_input_values_f iv2 -- Pay Value input value
2113: where ap.accrual_plan_id = p_accrual_plan_id
3504:
3505: CURSOR c_act_ann_pay(p_assignment_id number, p_element_entry_id number, p_assgt_action_id number,p_effective_date date) IS
3506: select prv.result_value
3507: from pay_run_result_values prv
3508: , pay_run_results prr
3509: , pay_input_values_f piv
3510: , pay_element_types_f pet
3511: , pay_element_entries_f pee
3512: where pet.element_name = 'Annual Leave Pay'