DBA Data[Home] [Help]

APPS.PAY_IN_PF_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1922: FROM pay_action_interlocks intk,

1918: AND ppa.effective_date between p_start_date and p_end_date
1919: AND paa.source_action_id IS NULL
1920: AND (1 = DECODE(ppa.action_type,'I',1,0)
1921: OR EXISTS (SELECT ''
1922: FROM pay_action_interlocks intk,
1923: pay_assignment_actions paa1,
1924: pay_payroll_actions ppa1
1925: WHERE intk.locked_action_id = paa.assignment_Action_id
1926: AND intk.locking_action_id = paa1.assignment_action_id