DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 239: FROM pay_assignment_actions act,

235: p_person_id NUMBER) IS
236: SELECT act.assignment_action_id,
237: act.assignment_id,
238: ppp.pre_payment_id
239: FROM pay_assignment_actions act,
240: per_all_assignments_f asg,
241: pay_payroll_actions pa2,
242: pay_payroll_actions pa1,
243: pay_pre_payments ppp,

Line 274: pay_assignment_actions act2,

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
278: AND act2.payroll_action_id = appa.payroll_action_id

Line 325: SELECT pay_assignment_actions_s.nextval

321: ,l_consolidation_set
322: ,l_assignment_set_id
323: ,l_person_id) LOOP
324:
325: SELECT pay_assignment_actions_s.nextval
326: INTO l_locking_action_id
327: FROM dual;
328:
329: