APPS.PAY_SA_UPGRADE dependencies on PAY_RUN_RESULTS

Line 56: SELECT /*+ INDEX(prr PAY_RUN_RESULTS_N50,PAY_RUN_RESULTS_N1) */ et.element_type_id

52: -- Get all run results for a set of elements where there doesnt exist a run result
53: -- value for the Joiner input value.
54: --
55: CURSOR csr_results IS
56: SELECT /*+ INDEX(prr PAY_RUN_RESULTS_N50,PAY_RUN_RESULTS_N1) */ et.element_type_id
57: ,et.element_name
58: ,iv.input_value_id
59: ,iv.name input_value_name
60: ,rr.run_result_id

Line 66: ,pay_run_results rr

62: ,aa.assignment_id
63: ,DECODE(et.element_name, 'GOSI', rr.element_entry_id, rr.source_id) element_entry_id
64: FROM pay_element_types_f et
65: ,pay_input_values_f iv
66: ,pay_run_results rr
67: ,pay_assignment_actions aa
68: WHERE et.element_name IN ('Employer GOSI Hazards'
69: ,'GOSI'
70: ,'Employee GOSI Annuities'