2892: FROM pay_assignment_actions
2893: WHERE assignment_action_id IN
2894: (
2895: SELECT LOCKED_ACTION_ID
2896: FROM pay_action_interlocks
2897: WHERE locking_action_id IN
2898: (
2899: SELECT ASSIGNMENT_ACTION_ID
2900: FROM pay_assignment_actions
3241: ( SELECT DISTINCT payroll_action_id
3242: FROM pay_assignment_actions
3243: WHERE assignment_action_id IN
3244: (SELECT LOCKED_ACTION_ID
3245: FROM pay_action_interlocks
3246: WHERE locking_action_id IN
3247: (SELECT ASSIGNMENT_ACTION_ID
3248: FROM pay_assignment_actions
3249: WHERE payroll_action_id = B_PAYROLL_ACTION_ID