[Home] [Help]
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
167: and pel.element_type_id = pet.element_type_id
168: and pet.element_type_id = pap.accrual_plan_element_type_id
169: and pee.entry_type ='E'
210: CURSOR csr_get_accrual_plan_id(p_assignment_id NUMBER
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
432:
433: --
434: cursor c_get_co_formula (v_accrual_plan_id number) is
435: select co_formula_id
436: from pay_accrual_plans
437: where accrual_plan_id = v_accrual_plan_id;
438: --
439: BEGIN
440: --
970: l_accrual_plan_id NUMBER;
971:
972: CURSOR csr_get_accrual_plan_id IS
973: SELECT accrual_plan_id
974: FROM pay_accrual_plans
975: WHERE NVL(business_group_id, p_business_group_id) = p_business_group_id
976: AND accrual_plan_name = p_accrual_plan_name;
977:
978:
1050: CURSOR csr_annual_leave_accrual_plan(c_business_group_id IN NUMBER
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
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,
1111: per_periods_of_service pps
1112: WHERE pev.element_entry_id = pee.element_entry_id
1113: AND pap.accrual_plan_element_type_id = piv.element_type_id
2003: l_eoy_adjustment number ;
2004: l_balance_type_id pay_balance_types.balance_type_id%type ;
2005: l_annual_leave_in_advance_hrs number ;
2006: l_annual_leave_in_advance_pay number ;
2007: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type ;
2008: l_start_date date ;
2009: l_end_date date ;
2010: l_accrual_end_date date ;
2011: l_accrual number ;
2062: -- cursor to get annual leave accrual plan
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
2096: ,p_assignment_id number
2097: ,p_year_end_date date) is
2098: select ab.absence_hours absence_hours
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
3748: ,v_end_date date) is
3749: select
3750: sum(nvl(to_number(pev1.screen_entry_value),0))
3751: from
3752: pay_accrual_plans pap
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2