APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 67: *** 16-Nov-06 abhargav 115.40 5603254 Modified cursor c_element_details to remove joins for pay_input_values_f piv2 and pay_run_result_values prrv2.

63: *** at the end of year
64: *** 27 Feb 06 ksingla 1.34 5063359 Modified Cursor c_element_details for employer charges
65: *** 19 Oct 06 ksingla 1.35 5461557 Modified cursor c_element_details to get rate and hours and group by on rate.
66: *** 29-Oct-06 hnainani 1.36 5603254 Added Function get_element_payment_hours to fetch hours in c_element_details.
67: *** 16-Nov-06 abhargav 115.40 5603254 Modified cursor c_element_details to remove joins for pay_input_values_f piv2 and pay_run_result_values prrv2.
68: *** 13-Feb-06 priupadh 115.41 N/A Version for restoring Triple Maintanence between 11i-->R12(Branch) -->R12(MainLine)
69: *** 02-MAR-07 hnainani 1.42 5599310 Added Function get_element_payment_rate to fetch rate in c_element_details.
70: -- 13-MAR-07 hnainani 115.43 5599310 Added Debug messages to function get_element_payment_rate
71: ***11-Jun-07 vamittal 115.44 6109668 Modified cursor get_rate_input_value in function get_element_payment_rate

Line 2881: ,pay_input_values_f piv

2877: prr.run_result_id,
2878: paa.source_action_id,
2879: paa2.tax_unit_id /*Bug 3935471*/
2880: from pay_element_types_f pet
2881: ,pay_input_values_f piv
2882: ,pay_element_classifications pec
2883: ,pay_assignment_actions paa
2884: ,pay_assignment_actions paa2 /*Bug 3935471*/
2885: ,pay_payroll_actions ppa

Line 3582: l_input_value_id pay_input_values_f.input_value_id%TYPE;

3578: RETURN NUMBER
3579: IS
3580:
3581: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3582: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3583:
3584: l_result number := NULL;
3585: l_temp NUMBER := NULL;
3586:

Line 3595: FROM pay_input_values_f pivf

3591: IS
3592: SELECT pivf.input_value_id
3593: ,pivf.name
3594: ,decode(pivf.name,'Hours',1,2) sort_index
3595: FROM pay_input_values_f pivf
3596: WHERE pivf.element_type_id = c_element_type_id
3597: AND substr(pivf.uom,1,1) = 'H'
3598: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
3599: ORDER BY sort_index;

Line 3664: l_input_value_id pay_input_values_f.input_value_id%TYPE;

3660: RETURN NUMBER
3661: IS
3662:
3663: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3664: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3665:
3666: l_result number := NULL;
3667:
3668: CURSOR get_rate_input_value

Line 3673: FROM pay_input_values_f pivf

3669: (c_element_type_id pay_element_types_f.element_type_id%TYPE
3670: ,c_effective_date date)
3671: IS
3672: SELECT pivf.input_value_id
3673: FROM pay_input_values_f pivf
3674: WHERE pivf.element_type_id = c_element_type_id
3675: AND upper(pivf.name) like 'RATE%'
3676: AND pivf.uom in ('N','M','I') /*bug 6109668 */
3677: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;