DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_ACTION_INTERLOCKS

Line 2841: pay_action_interlocks pai

2837: and not exists(
2838: select pai.locking_action_id
2839: from pay_assignment_actions paa1,
2840: pay_payroll_actions ppa1,
2841: pay_action_interlocks pai
2842: where ppa1.payroll_action_id = paa1.payroll_action_id
2843: and ppa1.action_type = 'V'
2844: and paa1.assignment_id = p_assignment_id
2845: and pai.locking_action_id = paa1.assignment_action_id

Line 3124: from pay_action_interlocks INTLK,

3120: ) return number
3121: is
3122: CURSOR Cr_action IS
3123: select INTLK.locking_action_id
3124: from pay_action_interlocks INTLK,
3125: pay_assignment_actions paa,
3126: pay_payroll_actions ppa
3127: where INTLK.locked_action_id = p_action_id
3128: and INTLK.locking_action_id = paa.assignment_action_id