DBA Data[Home] [Help]

APPS.PAY_P45_PKG2 dependencies on PAY_ACTION_INTERLOCKS

Line 320: FROM pay_action_interlocks pai,

316: AND assact2.action_status = 'C'
317: AND pact.effective_date <= to_date(p_date_earned,'YYYY/MM/DD')
318: AND NOT EXISTS(
319: SELECT '1'
320: FROM pay_action_interlocks pai,
321: pay_assignment_actions assact3,
322: pay_payroll_actions pact3
323: WHERE pai.locked_action_id = assact2.assignment_action_id
324: AND pai.locking_action_id = assact3.assignment_action_id