DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ACTION_INTERLOCKS

Line 117: FROM pay_action_interlocks pai1,

113: WHERE hr_asg.assignment_set_id = p_assignment_set_id
114: AND hr_asg.assignment_id = asg.assignment_id
115: ))
116: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
117: FROM pay_action_interlocks pai1,
118: pay_assignment_actions act2,
119: pay_payroll_actions appa
120: WHERE pai1.locked_action_id = act.assignment_action_id
121: AND act2.assignment_action_id = pai1.locking_action_id