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 1197: FROM pay_input_values_f pivf,

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