DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ACTION_INTERLOCKS

Line 189: FROM pay_action_interlocks pai1,

185: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
186: AND hr_asg.assignment_id = asg.assignment_id
187: ))
188: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
189: FROM pay_action_interlocks pai1,
190: pay_assignment_actions act2,
191: pay_payroll_actions appa
192: WHERE pai1.locked_action_id = act.assignment_action_id
193: AND act2.assignment_action_id = pai1.locking_action_id

Line 269: FROM pay_action_interlocks pai1,

265: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
266: AND hr_asg.assignment_id = asg.assignment_id
267: ))
268: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
269: FROM pay_action_interlocks pai1,
270: pay_assignment_actions act2,
271: pay_payroll_actions appa
272: WHERE pai1.locked_action_id = act.assignment_action_id
273: AND act2.assignment_action_id = pai1.locking_action_id