DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PAY_RUN_RESULTS

Line 286: pay_run_results rr

282: ,rr.run_result_id)
283: ,null) source_text2
284: from pay_assignment_actions aa,
285: pay_payroll_actions pa,
286: pay_run_results rr
287: where aa.ASSIGNMENT_ID = l_assignment_id
288: and aa.assignment_action_id = rr.assignment_action_id
289: and l_action_sequence >= aa.action_sequence
290: and aa.payroll_action_id = pa.payroll_action_id

Line 301: FROM pay_run_results rr

297: and legislation_code = 'SA';
298: --
299: cursor getRRstatus(l_ele_id number) IS
300: SELECT status
301: FROM pay_run_results rr
302: WHERE rr.assignment_action_id = p_assignment_action_id
303: AND rr.element_type_id = l_ele_id;
304: begin
305: l_rr_processed := null;