[Home] [Help]
269: WHERE hr_asg.assignment_set_id = p_assignment_set_id
270: AND hr_asg.assignment_id = asg.assignment_id
271: ))
272: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
273: FROM pay_action_interlocks pai1,
274: pay_assignment_actions act2,
275: pay_payroll_actions appa
276: WHERE pai1.locked_action_id = act.assignment_action_id
277: AND act2.assignment_action_id = pai1.locking_action_id