DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_ACTION_INTERLOCKS

Line 2896: FROM pay_action_interlocks

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

Line 3245: FROM pay_action_interlocks

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