APPS.PAY_INPUT_VALUES_PKG dependencies on PAY_RUN_RESULTS

Line 247: (select /*+ INDEX(RESULT PAY_RUN_RESULTS_PK) */ 1

243: cursor csr_value is
244: select 1
245: from dual
246: where exists
247: (select /*+ INDEX(RESULT PAY_RUN_RESULTS_PK) */ 1
248: from pay_run_result_values VALUE,
249: pay_run_results RESULT,
250: pay_assignment_actions ASSIGN,
251: pay_payroll_actions PAYROLL

Line 249: pay_run_results RESULT,

245: from dual
246: where exists
247: (select /*+ INDEX(RESULT PAY_RUN_RESULTS_PK) */ 1
248: from pay_run_result_values VALUE,
249: pay_run_results RESULT,
250: pay_assignment_actions ASSIGN,
251: pay_payroll_actions PAYROLL
252: where value.run_result_id = result.run_result_id
253: and assign.assignment_action_id = result.assignment_action_id