APPS.PAY_TEMPLATE_IVS dependencies on PAY_RUN_RESULTS

Line 184: FROM pay_run_results prr

180: 3a. Get run results that exist for the element type on which the input value
181: is being added:
182: SELECT DISTINCT prr.run_result_id
183: INTO l_run_result_id
184: FROM pay_run_results prr
185: AND prr.element_type_id = p_element_type_id -- ie. ele w/new iv.
186: ORDER BY prr.run_result_id;
187:
188:

Line 249: FROM pay_run_results prr

245: order by pev.effective_start_date;
246:
247: CURSOR get_results (p_eletype_id NUMBER) IS
248: SELECT prr.run_result_id
249: FROM pay_run_results prr
250: WHERE prr.element_type_id = p_eletype_id
251: ORDER BY prr.run_result_id;
252:
253:

Line 870: from pay_run_results rr

866: into v_validation_check
867: from sys.dual
868: where exists
869: (select 1
870: from pay_run_results rr
871: where rr.element_type_id = p_element_type_id);
872: --
873: exception
874: when NO_DATA_FOUND then null;