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;
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
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