APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ACTION_INTERLOCKS

Line 297: FROM pay_action_interlocks pai1,

293: WHERE hr_asg.assignment_set_id = p_assignment_set_id
294: AND hr_asg.assignment_id = asg.assignment_id
295: ))
296: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
297: FROM pay_action_interlocks pai1,
298: pay_assignment_actions act2,
299: pay_payroll_actions appa
300: WHERE pai1.locked_action_id = act.assignment_action_id
301: AND act2.assignment_action_id = pai1.locking_action_id