DBA Data[Home] [Help]

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

2884: ,pay_assignment_actions paa2 /*Bug 3935471*/
2885: ,pay_payroll_actions ppa
2886: ,per_assignments_f paaf
2887: ,pay_run_results prr
2888: ,pay_run_result_values prrv
2889: ,pay_element_classifications pec2
2890: ,pay_sub_classification_rules_f pscr
2891: where pet.element_type_id = piv.element_type_id
2892: and pet.element_type_id = prr.element_type_id

Line 3602: (c_run_result_id pay_run_result_values.run_result_id%TYPE

3598: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
3599: ORDER BY sort_index;
3600:
3601: CURSOR get_hours_result_value
3602: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3603: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3604: IS
3605: SELECT prrv.result_value
3606: FROM pay_run_result_values prrv

Line 3603: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

3599: ORDER BY sort_index;
3600:
3601: CURSOR get_hours_result_value
3602: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3603: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3604: IS
3605: SELECT prrv.result_value
3606: FROM pay_run_result_values prrv
3607: WHERE prrv.run_result_id = c_run_result_id

Line 3606: FROM pay_run_result_values prrv

3602: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3603: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3604: IS
3605: SELECT prrv.result_value
3606: FROM pay_run_result_values prrv
3607: WHERE prrv.run_result_id = c_run_result_id
3608: AND prrv.input_value_id = c_input_value_id;
3609:
3610: BEGIN

Line 3680: (c_run_result_id pay_run_result_values.run_result_id%TYPE

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;
3678:
3679: CURSOR get_rate_result_value
3680: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3681: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3682: IS
3683: SELECT prrv.result_value
3684: FROM pay_run_result_values prrv

Line 3681: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

3677: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date;
3678:
3679: CURSOR get_rate_result_value
3680: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3681: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3682: IS
3683: SELECT prrv.result_value
3684: FROM pay_run_result_values prrv
3685: WHERE prrv.run_result_id = c_run_result_id

Line 3684: FROM pay_run_result_values prrv

3680: (c_run_result_id pay_run_result_values.run_result_id%TYPE
3681: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
3682: IS
3683: SELECT prrv.result_value
3684: FROM pay_run_result_values prrv
3685: WHERE prrv.run_result_id = c_run_result_id
3686: AND prrv.input_value_id = c_input_value_id;
3687:
3688: BEGIN