[Home] [Help]
197: cursor csr_get_uom
198: (p_accrual_plan_id number
199: ) is
200: select accrual_units_of_measure
201: from pay_accrual_plans
202: where accrual_plan_id = p_accrual_plan_id;
203: --
204: begin
205: open csr_get_uom(p_accrual_plan_id);
1238: ) is
1239: select bnd.annual_rate annual_rate
1240: , acc.accrual_units_of_measure uom
1241: from pay_accrual_bands bnd
1242: , pay_accrual_plans acc
1243: where p_number_of_years >= bnd.lower_limit
1244: and p_number_of_years < bnd.upper_limit
1245: and bnd.accrual_plan_id = p_accrual_plan_id
1246: and bnd.accrual_plan_id = acc.accrual_plan_id;
1472: return number is
1473: --
1474: cursor csr_percentage(p_accrual_plan_id number) is
1475: select fnd_number.canonical_to_number(information1)
1476: from pay_accrual_plans pap
1477: where information_category = 'NZ_NZAL'
1478: and pap.accrual_plan_id = p_accrual_plan_id;
1479: --
1480: l_percentage number;
1706: --
1707: cursor c_get_co_formula
1708: (p_accrual_plan_id number) is
1709: select co_formula_id
1710: from pay_accrual_plans
1711: where accrual_plan_id = p_accrual_plan_id;
1712: --
1713: BEGIN
1714: --
2290: ,pay_element_entries_f pee
2291: ,pay_element_links_f pel
2292: ,pay_element_types_f abs_pet
2293: ,pay_input_values_f abs_piv
2294: ,pay_accrual_plans pap
2295: WHERE prr.run_result_id = prrv.run_result_id
2296: AND prr.assignment_action_id = c_assignment_action_id
2297: AND prr.element_type_id = alp_pet.element_type_id
2298: AND alp_pet.element_name = 'Annual Leave Payment'
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
2440: AND paf.assignment_id = c_assignment_id
2441: AND paa.business_group_id = c_business_group_id