[Home] [Help]
90: CURSOR csr_get_accrual_plan_id(p_assignment_id NUMBER
91: ,p_effective_date DATE
92: ,p_plan_category VARCHAR2) IS
93: SELECT pap.accrual_plan_id
94: FROM pay_accrual_plans pap,
95: pay_element_entries_f pee,
96: pay_element_links_f pel,
97: pay_element_types_f pet
98: WHERE pee.assignment_id = p_assignment_id
333: ---------------------------------------------
334:
335: cursor c_get_co_formula (v_accrual_plan_id number) is
336: select co_formula_id
337: from pay_accrual_plans
338: where accrual_plan_id = v_accrual_plan_id;
339:
340:
341:
539: CURSOR csr_annual_leave_accrual_plan(c_business_group_id IN NUMBER
540: ,c_calculation_date IN DATE
541: ,c_assignment_id IN NUMBER) IS
542: SELECT pap.accrual_plan_id
543: FROM pay_accrual_plans pap,
544: pay_element_entries_f pee,
545: pay_element_links_f pel,
546: pay_element_types_f pet
547: WHERE pel.element_link_id = pee.element_link_id
602: SELECT NVL(TO_DATE(pev.screen_entry_value,'YYYY/MM/DD HH24:MI:SS'),pps.date_start)
603: FROM pay_element_entries_f pee,
604: pay_element_entry_values_f pev,
605: pay_input_values_f piv,
606: pay_accrual_plans pap,
607: hr_lookups hrl,
608: per_assignments_f asg,
609: per_periods_of_service pps
610: WHERE pev.element_entry_id = pee.element_entry_id
1237: ,v_end_date date ) is
1238: select
1239: sum(nvl(to_number(pev1.screen_entry_value),0))
1240: from
1241: pay_accrual_plans pap
1242: ,pay_element_types_f pet
1243: ,pay_element_links_f pel
1244: ,pay_input_values_f piv1
1245: ,pay_input_values_f piv2
1408: -- find plan name
1409: cursor c_plan_name ( v_business_group_id number
1410: ,v_entry_value varchar2 ) is
1411: select 1
1412: from pay_accrual_plans pap
1413: where pap.business_group_id = v_business_group_id
1414: and pap.accrual_plan_name = v_entry_value;
1415:
1416: begin