APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1034: select pay_assignment_actions_s.nextval into l_asgact_id

1030: ,l_creating_alu_flag
1031: )
1032: loop
1033: --
1034: select pay_assignment_actions_s.nextval into l_asgact_id
1035: from dual;
1036: --
1037: -- Create assignment action.
1038: --

Line 1137: from pay_assignment_actions

1133: --
1134: hr_utility.set_location('Entering: '||l_proc, 5);
1135: --
1136: select assignment_id into l_asgid
1137: from pay_assignment_actions
1138: where assignment_action_id = p_assactid;
1139:
1140: --
1141: -- Loop until timeout setting allows for locking.

Line 1204: from pay_assignment_actions paa

1200: select 'I'
1201: from dual
1202: where exists
1203: (select null
1204: from pay_assignment_actions paa
1205: where paa.payroll_action_id = p_payroll_action_id
1206: and paa.action_status <> 'C')
1207: union all
1208: select ppa.action_status