APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_RUN_RESULT_VALUES

Line 145: (c_run_result_id pay_run_result_values.run_result_id%TYPE

141: AND c_effective_date between pivf.effective_start_date and pivf.effective_end_date
142: ORDER BY sort_index;
143:
144: CURSOR get_hours_result_value
145: (c_run_result_id pay_run_result_values.run_result_id%TYPE
146: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
147: IS
148: SELECT prrv.result_value
149: FROM pay_run_result_values prrv

Line 146: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)

142: ORDER BY sort_index;
143:
144: CURSOR get_hours_result_value
145: (c_run_result_id pay_run_result_values.run_result_id%TYPE
146: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
147: IS
148: SELECT prrv.result_value
149: FROM pay_run_result_values prrv
150: WHERE prrv.run_result_id = c_run_result_id

Line 149: FROM pay_run_result_values prrv

145: (c_run_result_id pay_run_result_values.run_result_id%TYPE
146: ,c_input_value_id pay_run_result_values.input_value_id%TYPE)
147: IS
148: SELECT prrv.result_value
149: FROM pay_run_result_values prrv
150: WHERE prrv.run_result_id = c_run_result_id
151: AND prrv.input_value_id = c_input_value_id;
152:
153:

Line 1760: ,pay_run_result_values prrv

1756: ,pet.element_type_id element_type_id
1757: FROM pay_payroll_actions ppa
1758: ,pay_assignment_actions paa
1759: ,pay_run_results prr
1760: ,pay_run_result_values prrv
1761: ,pay_input_values_f piv
1762: ,pay_element_types_f pet
1763: ,pay_element_types_f_tl petl
1764: ,pay_element_classifications pec

Line 1846: ,pay_run_result_values prrv

1842: ,pet.element_type_id element_type_id
1843: FROM pay_payroll_actions ppa
1844: ,pay_assignment_actions paa
1845: ,pay_run_results prr
1846: ,pay_run_result_values prrv
1847: ,pay_input_values_f piv
1848: ,pay_element_types_f pet
1849: ,pay_element_types_f_tl petl
1850: ,pay_element_classifications pec

Line 3372: ,pay_run_result_values prrv

3368: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
3369: FROM pay_assignment_actions paa
3370: ,pay_payroll_actions ppa
3371: ,pay_run_results prr
3372: ,pay_run_result_values prrv
3373: ,per_time_periods ptp
3374: ,pay_element_types_f pet
3375: ,pay_input_values_f piv
3376: ,pay_element_entries_f pee