APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

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 1684: ,pay_run_result_values prrv

1680: ,pay_assignment_actions paa2 /*Bug 3935471*/
1681: ,pay_payroll_actions ppa
1682: ,per_assignments_f paaf
1683: ,pay_run_results prr
1684: ,pay_run_result_values prrv
1685: ,pay_element_classifications pec2
1686: ,pay_sub_classification_rules_f pscr
1687: where pet.element_type_id = piv.element_type_id
1688: and pet.element_type_id = prr.element_type_id

Line 2398: (c_run_result_id pay_run_result_values.run_result_id%TYPE

2394: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
2395: ORDER BY sort_index;
2396:
2397: CURSOR get_hours_result_value
2398: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2399: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2400: IS
2401: SELECT prrv.result_value
2402: FROM pay_run_result_values prrv

Line 2399: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

2395: ORDER BY sort_index;
2396:
2397: CURSOR get_hours_result_value
2398: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2399: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2400: IS
2401: SELECT prrv.result_value
2402: FROM pay_run_result_values prrv
2403: WHERE prrv.run_result_id = c_run_result_id

Line 2402: FROM pay_run_result_values prrv

2398: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2399: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2400: IS
2401: SELECT prrv.result_value
2402: FROM pay_run_result_values prrv
2403: WHERE prrv.run_result_id = c_run_result_id
2404: AND prrv.input_value_id = c_input_value_id;
2405:
2406: BEGIN

Line 2476: (c_run_result_id pay_run_result_values.run_result_id%TYPE

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;
2474:
2475: CURSOR get_rate_result_value
2476: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2477: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2478: IS
2479: SELECT prrv.result_value
2480: FROM pay_run_result_values prrv

Line 2477: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

2473: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
2474:
2475: CURSOR get_rate_result_value
2476: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2477: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2478: IS
2479: SELECT prrv.result_value
2480: FROM pay_run_result_values prrv
2481: WHERE prrv.run_result_id = c_run_result_id

Line 2480: FROM pay_run_result_values prrv

2476: (c_run_result_id pay_run_result_values.run_result_id%TYPE
2477: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
2478: IS
2479: SELECT prrv.result_value
2480: FROM pay_run_result_values prrv
2481: WHERE prrv.run_result_id = c_run_result_id
2482: AND prrv.input_value_id = c_input_value_id;
2483:
2484: BEGIN