APPS.HR_RUNGEN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 26: FROM pay_assignment_actions ASA

22: IS
23: --
24: CURSOR get_asg_ids (p_pyrll_action_id NUMBER) IS
25: SELECT ASA.assignment_id
26: FROM pay_assignment_actions ASA
27: WHERE ASA.payroll_action_id = p_pyrll_action_id
28: AND ASA.action_status = 'C';
29: --
30: l_set_name VARCHAR2(80);

Line 279: FROM pay_assignment_actions ASA

275: IS
276: --
277: CURSOR get_asg_ids (p_pyrll_action_id NUMBER) IS
278: SELECT ASA.assignment_id
279: FROM pay_assignment_actions ASA
280: WHERE ASA.payroll_action_id = p_pyrll_action_id
281: AND ASA.action_status = 'C';
282: --
283: l_set_name VARCHAR2(80);

Line 458: from pay_assignment_actions

454: select 1
455: into dummy
456: from sys.dual
457: where exists (select ''
458: from pay_assignment_actions
459: where payroll_action_id = p_payroll_act_id
460: and action_status <> 'C');
461: --
462: p_req_id := fnd_request.submit_request(

Line 680: from pay_assignment_actions asg2,

676: begin
677: --
678: select distinct asg2.payroll_action_id
679: into l_prepay_id
680: from pay_assignment_actions asg2,
681: pay_action_interlocks pai,
682: pay_payroll_actions ppa,
683: pay_assignment_actions asg1
684: where asg1.payroll_action_id = actrec.payroll_action_id

Line 683: pay_assignment_actions asg1

679: into l_prepay_id
680: from pay_assignment_actions asg2,
681: pay_action_interlocks pai,
682: pay_payroll_actions ppa,
683: pay_assignment_actions asg1
684: where asg1.payroll_action_id = actrec.payroll_action_id
685: and asg1.assignment_action_id = pai.locked_action_id
686: and asg2.assignment_action_id = pai.locking_action_id
687: and ppa.payroll_action_id = asg2.payroll_action_id