APPS.PAY_HK_IR56_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 292: FROM pay_action_interlocks pai,

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