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
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