DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 2774: FROM pay_action_interlocks intk,

2770: AND paa.source_action_id IS NULL
2771: AND ppa.payroll_id = paf.payroll_id
2772: AND (1 = DECODE(ppa.action_type,'I',1,0)
2773: OR EXISTS (SELECT ''
2774: FROM pay_action_interlocks intk,
2775: pay_assignment_actions paa1,
2776: pay_payroll_actions ppa1
2777: WHERE intk.locked_action_id = paa.assignment_Action_id
2778: AND intk.locking_action_id = paa1.assignment_action_id

Line 2800: pay_action_interlocks intk

2796: IS
2797: SELECT ppa.effective_date
2798: FROM pay_payroll_actions ppa,
2799: pay_assignment_actions paa,
2800: pay_action_interlocks intk
2801: WHERE intk.locked_action_id = l_run_assact
2802: AND intk.locking_action_id =paa.assignment_action_id
2803: AND ppa.payroll_action_id = paa.payroll_action_id
2804: AND ppa.action_type IN('P','U');