DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ACTION_INTERLOCKS

Line 273: FROM pay_action_interlocks pai1,

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