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 1677: ,pay_input_values_f piv

1673: prr.run_result_id,
1674: paa.source_action_id,
1675: paa2.tax_unit_id /*Bug 3935471*/
1676: from pay_element_types_f pet
1677: ,pay_input_values_f piv
1678: ,pay_element_classifications pec
1679: ,pay_assignment_actions paa
1680: ,pay_assignment_actions paa2 /*Bug 3935471*/
1681: ,pay_payroll_actions ppa

Line 2378: l_input_value_id pay_input_values_f.input_value_id%TYPE;

2374: RETURN NUMBER
2375: IS
2376:
2377: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2378: l_input_value_id pay_input_values_f.input_value_id%TYPE;
2379:
2380: l_result number := NULL;
2381: l_temp NUMBER := NULL;
2382:

Line 2391: FROM pay_input_values_f pivf

2387: IS
2388: SELECT pivf.input_value_id
2389: ,pivf.name
2390: ,decode(pivf.name,'Hours',1,2) sort_index
2391: FROM pay_input_values_f pivf
2392: WHERE pivf.element_type_id = c_element_type_id
2393: AND substr(pivf.uom,1,1) = 'H'
2394: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
2395: ORDER BY sort_index;

Line 2460: l_input_value_id pay_input_values_f.input_value_id%TYPE;

2456: RETURN NUMBER
2457: IS
2458:
2459: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2460: l_input_value_id pay_input_values_f.input_value_id%TYPE;
2461:
2462: l_result number := NULL;
2463:
2464: CURSOR get_rate_input_value

Line 2469: FROM pay_input_values_f pivf

2465: (c_element_type_id pay_element_types_f.element_type_id%TYPE
2466: ,c_effective_date date)
2467: IS
2468: SELECT pivf.input_value_id
2469: FROM pay_input_values_f pivf
2470: WHERE pivf.element_type_id = c_element_type_id
2471: AND upper(pivf.name) like 'RATE%'
2472: AND pivf.uom in ('N','M','I') /*bug 6109668 */
2473: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;