DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 437: SELECT pay_assignment_actions_s.nextval

433: close csr_locking_archive;
434: end if;
435: if l_create_act then
436: -- insert the new assignment action
437: SELECT pay_assignment_actions_s.nextval
438: INTO l_actid
439: FROM dual;
440: hr_nonrun_asact.insact( l_actid
441: , rec_assact.assignment_id

Line 541: ,pay_assignment_actions_s.nextval new_ass_act_id

537: ,runchild.payroll_action_id
538: ,runchild.assignment_action_id
539: ,runchild.assignment_id
540: ,runchild.tax_unit_id
541: ,pay_assignment_actions_s.nextval new_ass_act_id
542: FROM pay_assignment_actions assact
543: ,pay_action_interlocks interlock
544: ,pay_assignment_actions runchild
545: WHERE assact.assignment_action_id = p_assignment_action_id

Line 552: ,pay_assignment_actions_s.nextval new_ass_act_id

548:
549: CURSOR csr_grand_child (p_child_action_id in number) is
550: SELECT assact.assignment_action_id
551: ,assact.tax_unit_id
552: ,pay_assignment_actions_s.nextval new_ass_act_id
553: FROM pay_assignment_actions assact
554: WHERE assact.source_action_id = p_child_action_id;
555: --
556: l_locked_action csr_locked_action_info%ROWTYPE;