DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ACTION_INTERLOCKS

Line 125: FROM pay_action_interlocks pai1,

121: AND hr_asg.assignment_id = asg.assignment_id
122: AND hr_asg.INCLUDE_OR_EXCLUDE = 'I'
123: ))
124: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
125: FROM pay_action_interlocks pai1,
126: pay_assignment_actions act2,
127: pay_payroll_actions appa
128: WHERE pai1.locked_action_id = act.assignment_action_id
129: AND act2.assignment_action_id = pai1.locking_action_id