APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 2480: FROM pay_action_interlocks intk,

2476: AND ppa.effective_date between p_start_date and p_end_date
2477: AND paa.source_action_id IS NULL
2478: AND (1 = DECODE(ppa.action_type,'I',1,0)
2479: OR EXISTS (SELECT ''
2480: FROM pay_action_interlocks intk,
2481: pay_assignment_actions paa1,
2482: pay_payroll_actions ppa1
2483: WHERE intk.locked_action_id = paa.assignment_Action_id
2484: AND intk.locking_action_id = paa1.assignment_action_id