APPS.PAY_KW_PIFSS dependencies on PAY_ACTION_INTERLOCKS

Line 66: FROM pay_action_interlocks pail

62: and ppaa.payroll_Action_id = ppac1.payroll_action_id
63: group by ppac1.assignment_id)
64: and not exists
65: (select locked_action_id
66: FROM pay_action_interlocks pail
67: WHERE pail.locked_action_id=ppac.assignment_action_id);
68: cursor next_action_id is
69: select pay_assignment_actions_s.nextval
70: from dual;