[Home] [Help]
158: CURSOR csr_acp_start_date(p_assignment_id IN NUMBER
159: ,p_plan_id IN NUMBER
160: ,p_effective_date IN DATE) IS
161: SELECT LEAST(PEE.EFFECTIVE_START_DATE)
162: FROM pay_element_entries_f pee,
163: pay_element_links_f pel,
164: pay_element_types_f pet,
165: pay_accrual_plans pap
166: where pee.element_link_id = pel.element_link_id
211: ,p_effective_date DATE
212: ,p_plan_category VARCHAR2) IS
213: SELECT pap.accrual_plan_id
214: FROM pay_accrual_plans pap,
215: pay_element_entries_f pee,
216: pay_element_links_f pel,
217: pay_element_types_f pet
218: WHERE pee.assignment_id = p_assignment_id
219: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1051: ,c_calculation_date IN DATE
1052: ,c_assignment_id IN NUMBER) IS
1053: SELECT pap.accrual_plan_id
1054: FROM pay_accrual_plans pap,
1055: pay_element_entries_f pee,
1056: pay_element_links_f pel,
1057: pay_element_types_f pet
1058: WHERE pel.element_link_id = pee.element_link_id
1059: AND pel.element_type_id = pet.element_type_id
1102: ,c_accrual_plan_id NUMBER
1103: ,c_calculation_date DATE
1104: ,c_assignment_id NUMBER) IS
1105: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
1106: FROM pay_element_entries_f pee,
1107: pay_element_entry_values_f pev,
1108: pay_input_values_f piv,
1109: pay_accrual_plans pap,
1110: per_all_assignments_f asg,
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
1442: , per_time_periods tp
2063: cursor c_annual_leave_plan(p_assignment_id number
2064: ,p_effective_date date) is
2065: select pap.accrual_plan_id
2066: from pay_accrual_plans pap
2067: , pay_element_entries_f pee
2068: , pay_element_links_f pel
2069: , pay_element_types_f pet
2070: where pee.assignment_id = p_assignment_id
2071: and p_effective_date between pee.effective_start_date
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
2090: -- Leave Pay" element is the amount paid for the leave.
2091:
2099: , to_number(rrv2.result_value) absence_pay
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
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'
3513: and pet.legislation_code = 'NZ'
3514: and pet.element_type_id = piv.element_type_id
3515: and piv.name = 'Pay Value'
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1
3759: ,pay_element_entry_values_f pev2
3760: where
3761: pee.assignment_id = v_assignment_id
3820:
3821: cursor c_check_retro(p_element_entry_id in number)
3822: is
3823: select 'EXISTS'
3824: from pay_element_entries_f pee
3825: where pee.element_entry_id = p_element_entry_id
3826: and pee.creator_type = 'RR';
3827:
3828: begin