APPS.PAY_IN_EOY_REPORTS dependencies on PAY_ACTION_INTERLOCKS

Line 517: FROM pay_action_interlocks intk,

513: AND ppa.effective_date between p_qtr_start and p_qtr_end
514: AND paa.source_action_id IS NULL
515: AND (1 = DECODE(ppa.action_type,'I',1,0)
516: OR EXISTS (SELECT ''
517: FROM pay_action_interlocks intk,
518: pay_assignment_actions paa1,
519: pay_payroll_actions ppa1
520: WHERE intk.locked_action_id = paa.assignment_Action_id
521: AND intk.locking_action_id = paa1.assignment_action_id