DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 263: FROM pay_assignment_actions act,

259: p_person_id NUMBER) IS
260: SELECT act.assignment_action_id,
261: act.assignment_id,
262: ppp.pre_payment_id
263: FROM pay_assignment_actions act,
264: per_all_assignments_f asg,
265: pay_payroll_actions pa2,
266: pay_payroll_actions pa1,
267: pay_pre_payments ppp,

Line 298: pay_assignment_actions act2,

294: AND hr_asg.assignment_id = asg.assignment_id
295: ))
296: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
297: FROM pay_action_interlocks pai1,
298: pay_assignment_actions act2,
299: pay_payroll_actions appa
300: WHERE pai1.locked_action_id = act.assignment_action_id
301: AND act2.assignment_action_id = pai1.locking_action_id
302: AND act2.payroll_action_id = appa.payroll_action_id

Line 349: SELECT pay_assignment_actions_s.nextval

345: ,l_consolidation_set
346: ,l_assignment_set_id
347: ,l_person_id) LOOP
348:
349: SELECT pay_assignment_actions_s.nextval
350: INTO l_locking_action_id
351: FROM dual;
352:
353: