DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_ACTION_INTERLOCKS

Line 2092: pay_action_interlocks pai

2088: and not exists(
2089: select pai.locking_action_id
2090: from pay_assignment_actions paa1,
2091: pay_payroll_actions ppa1,
2092: pay_action_interlocks pai
2093: where ppa1.payroll_action_id = paa1.payroll_action_id
2094: and ppa1.action_type = 'V'
2095: and paa1.assignment_id = p_assignment_id
2096: and pai.locking_action_id = paa1.assignment_action_id

Line 2375: from pay_action_interlocks INTLK,

2371: ) return number
2372: is
2373: CURSOR Cr_action IS
2374: select INTLK.locking_action_id
2375: from pay_action_interlocks INTLK,
2376: pay_assignment_actions paa,
2377: pay_payroll_actions ppa
2378: where INTLK.locked_action_id = p_action_id
2379: and INTLK.locking_action_id = paa.assignment_action_id