APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 294: FROM pay_action_interlocks pai,

290: AND pps.period_of_service_id = a.period_of_service_id
291: AND pps.person_id = a.person_id
292: AND NOT EXISTS -- don't produce if they've had ir56b report produced.
293: (SELECT NULL
294: FROM pay_action_interlocks pai,
295: pay_payroll_actions ppai,
296: pay_payroll_actions ppaa,
297: pay_assignment_actions paa
298: WHERE paa.assignment_id = a.assignment_id