DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ACTION_INTERLOCKS

Line 209: FROM pay_action_interlocks pai1,

205: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
206: AND hr_asg.assignment_id = asg.assignment_id
207: ))
208: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
209: FROM pay_action_interlocks pai1,
210: pay_assignment_actions act2,
211: pay_payroll_actions appa
212: WHERE pai1.locked_action_id = act.assignment_action_id
213: AND act2.assignment_action_id = pai1.locking_action_id

Line 291: FROM pay_action_interlocks pai1,

287: WHERE hr_asg.assignment_set_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ASSIGNMENT_SET_ID'))
288: AND hr_asg.assignment_id = asg.assignment_id
289: ))
290: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
291: FROM pay_action_interlocks pai1,
292: pay_assignment_actions act2,
293: pay_payroll_actions appa
294: WHERE pai1.locked_action_id = act.assignment_action_id
295: AND act2.assignment_action_id = pai1.locking_action_id