APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS
Line 2586: FROM pay_action_interlocks intk,
2582: AND ppa.effective_date between p_start_date and p_end_date
2583: AND paa.source_action_id IS NULL
2584: AND (1 = DECODE(ppa.action_type,'I',1,0)
2585: OR EXISTS (SELECT '' 2586: FROM pay_action_interlocks intk, 2587: pay_assignment_actions paa1,
2588: pay_payroll_actions ppa1
2589: WHERE intk.locked_action_id = paa.assignment_Action_id
2590: AND intk.locking_action_id = paa1.assignment_action_id