APPS.PAY_CA_PAYRG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 569: select pay_assignment_actions_s.nextval

565:
566: if ( ( ln_source_action_id <> prev_source_action_id ) or
567: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
568:
569: select pay_assignment_actions_s.nextval
570: into lockingactid
571: from dual;
572:
573: -- insert the action record.

Line 590: -- update pay_assignment_actions serial_number with

586: lv_sep_check ||
587: nvl(lv_multi_asg_flag,'N') ||
588: to_char(ln_max_run_aa_id);
589:
590: -- update pay_assignment_actions serial_number with
591: -- runactid.
592:
593: update pay_assignment_actions
594: set serial_number = serialno

Line 700: select pay_assignment_actions_s.nextval

696: end loop; -- c_payment_info
697: close c_payment_info;
698: else
699:
700: select pay_assignment_actions_s.nextval
701: into lockingactid
702: from dual;
703:
704: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||

Line 718: -- update pay_assignment_actions serial_number with runactid.

714:
715: begin
716: --serialno := 'V'||to_char(runactid);
717: serialno := actiontype || 'NN' || to_char(lockedactid);
718: -- update pay_assignment_actions serial_number with runactid.
719: update pay_assignment_actions
720: set serial_number = serialno
721: where assignment_action_id = lockingactid
722: and tax_unit_id = greid;