APPS.HR_INPUT_VALUES dependencies on PAY_RUN_RESULTS

Line 266: from pay_run_results rr

262: into v_validation_check
263: from sys.dual
264: where exists
265: (select 1
266: from pay_run_results rr
267: where rr.element_type_id = p_element_type_id);
268: --
269: exception
270: when NO_DATA_FOUND then null;

Line 700: (select /*+ INDEX(rr PAY_RUN_RESULTS_PK) */ 1

696: select 'Y'
697: into v_run_results_exist_flag
698: from sys.dual
699: where exists
700: (select /*+ INDEX(rr PAY_RUN_RESULTS_PK) */ 1
701: from pay_run_result_values rrv,
702: pay_run_results rr,
703: pay_assignment_actions aa,
704: pay_payroll_actions pa

Line 702: pay_run_results rr,

698: from sys.dual
699: where exists
700: (select /*+ INDEX(rr PAY_RUN_RESULTS_PK) */ 1
701: from pay_run_result_values rrv,
702: pay_run_results rr,
703: pay_assignment_actions aa,
704: pay_payroll_actions pa
705: where p_input_value_id = rrv.input_value_id
706: and rrv.run_result_id = rr.run_result_id