DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 244: SELECT pay_assignment_actions_s.nextval

240: LOOP
241: Fetch csr_assignments into rec_this;
242: EXIT WHEN csr_assignments%NOTFOUND;
243: -- create the action
244: SELECT pay_assignment_actions_s.nextval
245: INTO l_actid
246: FROM dual;
247: hr_nonrun_asact.insact(l_actid
248: ,rec_this.assignment_id

Line 519: ,pay_assignment_actions_s.nextval new_ass_act_id

515: ,child_pre.assignment_id assignment_id
516: ,child_pre.tax_unit_id establishment_id
517: ,master_arc.chunk_number chunk_number
518: ,master_arc.payroll_action_id payroll_action_id
519: ,pay_assignment_actions_s.nextval new_ass_act_id
520: FROM pay_assignment_Actions master_arc
521: ,pay_action_interlocks lok
522: ,pay_assignment_Actions child_pre
523: WHERE master_arc.assignment_action_id = p_assactid