DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PAY_RUN_RESULTS

Line 283: pay_run_results rr

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

Line 298: FROM pay_run_results rr

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