APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_ACTION_INTERLOCKS

Line 126: FROM pay_action_interlocks pai1,

122: WHERE hr_asg.assignment_set_id = p_assignment_set_id
123: AND hr_asg.assignment_id = asg.assignment_id
124: ))
125: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
126: FROM pay_action_interlocks pai1,
127: pay_assignment_actions act2,
128: pay_payroll_actions appa
129: WHERE pai1.locked_action_id = act.assignment_action_id
130: AND act2.assignment_action_id = pai1.locking_action_id