DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_ACTION_INTERLOCKS

Line 2901: FROM pay_action_interlocks

2897: FROM pay_assignment_actions
2898: WHERE assignment_action_id IN
2899: (
2900: SELECT LOCKED_ACTION_ID
2901: FROM pay_action_interlocks
2902: WHERE locking_action_id IN
2903: (
2904: SELECT ASSIGNMENT_ACTION_ID
2905: FROM pay_assignment_actions

Line 3250: FROM pay_action_interlocks

3246: ( SELECT DISTINCT payroll_action_id
3247: FROM pay_assignment_actions
3248: WHERE assignment_action_id IN
3249: (SELECT LOCKED_ACTION_ID
3250: FROM pay_action_interlocks
3251: WHERE locking_action_id IN
3252: (SELECT ASSIGNMENT_ACTION_ID
3253: FROM pay_assignment_actions
3254: WHERE payroll_action_id = B_PAYROLL_ACTION_ID