APPS.PAY_SA_UPGRADE dependencies on PAY_RUN_RESULT_VALUES

Line 82: FROM pay_run_result_values rrv

78: AND iv.name = 'Joiner'
79: AND rr.element_type_id = et.element_type_id
80: AND aa.assignment_action_id = rr.assignment_action_id
81: AND NOT EXISTS (SELECT NULL
82: FROM pay_run_result_values rrv
83: WHERE rrv.run_result_id = rr.run_result_id
84: AND rrv.input_value_id = iv.input_value_id)
85: ORDER BY aa.assignment_action_id;
86: --

Line 201: INSERT INTO pay_run_result_values

197: --
198: --
199: -- Create the run result values.
200: --
201: INSERT INTO pay_run_result_values
202: (run_result_id
203: ,input_value_id
204: ,result_value)
205: SELECT l_result_rec.run_result_id