DBA Data[Home] [Help]

APPS.PAY_IN_EOY_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 2679: FROM pay_action_interlocks intk,

2675: AND paa.source_action_id IS NULL
2676: AND ppa.payroll_id = paf.payroll_id
2677: AND (1 = DECODE(ppa.action_type,'I',1,0)
2678: OR EXISTS (SELECT ''
2679: FROM pay_action_interlocks intk,
2680: pay_assignment_actions paa1,
2681: pay_payroll_actions ppa1
2682: WHERE intk.locked_action_id = paa.assignment_Action_id
2683: AND intk.locking_action_id = paa1.assignment_action_id

Line 2705: pay_action_interlocks intk

2701: IS
2702: SELECT ppa.effective_date
2703: FROM pay_payroll_actions ppa,
2704: pay_assignment_actions paa,
2705: pay_action_interlocks intk
2706: WHERE intk.locked_action_id = l_run_assact
2707: AND intk.locking_action_id =paa.assignment_action_id
2708: AND ppa.payroll_action_id = paa.payroll_action_id
2709: AND ppa.action_type IN('P','U');