APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 178: pay_input_values_f pivf

174: SELECT fnd_number.canonical_to_number(prrv.result_value)
175: FROM pay_assignment_actions paa,
176: pay_run_results prr,
177: pay_run_result_values prrv,
178: pay_input_values_f pivf
179: WHERE prr.run_result_id = c_run_result_id
180: AND paa.assignment_action_id = c_assignment_action_id
181: AND prr.run_result_id = prrv.run_result_id
182: AND prrv.input_value_id = pivf.input_value_id

Line 1196: FROM pay_input_values_f pivf,

1192: l_assessed_ri pay_run_result_values.result_value%TYPE;
1193: CURSOR csr_get_accessed_ri
1194: IS
1195: SELECT prrv.result_value
1196: FROM pay_input_values_f pivf,
1197: pay_run_result_values prrv
1198: WHERE prrv.run_result_id = p_run_result_id
1199: AND pivf.input_value_id = prrv.input_value_id
1200: AND pivf.name = 'Assessed RI';