[Home] [Help]
1578: ,p_effective_date DATE) IS
1579: SELECT prv.result_value value
1580: ,prv1.result_value si_type
1581: FROM pay_run_result_values prv
1582: ,pay_run_results prr
1583: ,pay_input_values_f piv
1584: ,pay_input_values_f piv1
1585: ,pay_run_result_values prv1
1586: ,pay_element_types_f pet
1607: --
1608: CURSOR csr_emp_phc_applies(p_assgn_action_id NUMBER
1609: ,p_date_earned DATE) IS
1610: SELECT 1
1611: FROM pay_run_results prr
1612: ,pay_element_types_f pet
1613: WHERE
1614: pet.element_name = 'Private Health Insurance'
1615: AND prr.assignment_action_id=p_assgn_action_id
1621: Cursor get_prev_year_salary (p_asg_act_id number
1622: ,p_date_earned date) is
1623: select result_value
1624: from pay_run_result_values prrv
1625: , pay_run_results prr
1626: ,pay_element_types_f pet
1627: ,pay_input_values_f piv
1628: where prrv.run_result_id=prr.run_result_id
1629: and prr.assignment_action_id=p_asg_act_id
2137: ,p_element_type_id NUMBER
2138: ,p_input_value_id NUMBER) IS
2139: SELECT prv.result_value
2140: FROM pay_run_result_values prv
2141: ,pay_run_results prr
2142: WHERE prr.status IN ('P','PA')
2143: AND prv.run_result_id = prr.run_result_id
2144: AND prr.assignment_action_id = p_assignment_action_id
2145: AND prr.element_type_id = p_element_type_id
2153: ,p_effective_date DATE) IS
2154: SELECT prv.result_value value
2155: ,prv1.result_value si_type
2156: FROM pay_run_result_values prv
2157: ,pay_run_results prr
2158: ,pay_input_values_f piv
2159: ,pay_run_result_values prv1
2160: WHERE prr.status IN ('P','PA')
2161: AND prv.run_result_id = prr.run_result_id
2190: ,p_effective_date DATE) IS
2191: Select prv1.result_value si_type_name
2192: From
2193: pay_run_result_values prv
2194: ,pay_run_results prr
2195: ,pay_input_values_f piv
2196: ,pay_run_result_values prv1
2197: ,pay_input_values_f piv1
2198: where prr.status in ('P','PA')
2437: ,pay_input_values_f piv
2438: ,pay_input_values_f piv1
2439: ,pay_input_values_f piv2
2440: ,pay_element_types_f pet
2441: ,pay_run_results prr
2442: ,pay_run_result_values prrv
2443: ,pay_run_result_values prrv1
2444: WHERE pbf.balance_type_id = pbt.balance_type_id
2445: AND pbt.balance_name = p_balance_name
2739: ,pet.business_group_id business_group_id
2740: ,prv.run_result_id run_result_id
2741:
2742: FROM pay_run_result_values prv
2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2772: ,p_input_value_name VARCHAR2
2773: ,p_date_earned DATE) IS
2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2810: ,pet.processing_priority priority
2811: ,pet.business_group_id business_group_id
2812: ,prv.run_result_id run_result_id /* 4389520*/
2813: FROM pay_run_result_values prv
2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2880: ,p_input_value_name VARCHAR2
2881: ,p_date_earned DATE) IS
2882: SELECT prv.result_value value
2883: FROM pay_run_result_values prv
2884: ,pay_run_results prr
2885: ,pay_element_types_f pet
2886: ,pay_input_values_f piv
2887: ,pay_element_classifications pec
2888: WHERE prr.status IN ('P','PA')
2957: l_element_retro_entries element_retro_entries;
2958: type creator_type is table of varchar2(2) index by binary_integer;
2959: l_creator_type creator_type;
2960: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2961: l_run_result_id pay_run_results.run_result_id%TYPE;
2962: l_corr_bal_name pay_balance_types.balance_name%TYPE;
2963:
2964: BEGIN
2965:
3821: ,pay_input_values_f piv
3822: ,pay_input_values_f piv1
3823: ,pay_input_values_f piv2
3824: ,pay_element_types_f pet
3825: ,pay_run_results prr
3826: ,pay_run_result_values prrv
3827: ,pay_run_result_values prrv1
3828: WHERE pbf.balance_type_id = pbt.balance_type_id
3829: AND pbt.balance_name like p_balance_name||'%'
3859:
3860: CURSOR csr_emp_phc_applies(p_assgn_action_id NUMBER
3861: ,p_date_earned DATE) IS
3862: SELECT 1
3863: FROM pay_run_results prr
3864: ,pay_element_types_f pet
3865: WHERE
3866: pet.element_name = 'Private Health Insurance'
3867: AND prr.assignment_action_id=p_assgn_action_id
4517: FROM pay_balance_feeds_f pbf
4518: ,pay_balance_types pbt
4519: ,pay_input_values_f piv
4520: ,pay_element_types_f pet
4521: ,pay_run_results prr
4522: WHERE pbf.balance_type_id = pbt.balance_type_id
4523: AND (pbt.balance_name like p_balance_name||'%'
4524: OR pbt.balance_name like nvl(p_standard_bal_name,p_balance_name)||'%'
4525: OR pbt.balance_name like nvl(p_special_bal_name,p_balance_name)||'%')
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4568: ,pay_run_result_values prrv
4569: ,pay_element_entries_f pee
4570: WHERE pbf.balance_type_id = pbt.balance_type_id
4571: AND prr.source_id = pee.element_entry_id
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2
4618: ,pay_element_entries_f pee