APPS.PAY_CA_PAYRG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 574: select pay_assignment_actions_s.nextval

570:
571: if ( ( ln_source_action_id <> prev_source_action_id ) or
572: ( ln_tax_unit_id <> prev_tax_unit_id ) ) then
573:
574: select pay_assignment_actions_s.nextval
575: into lockingactid
576: from dual;
577:
578: -- insert the action record.

Line 595: -- update pay_assignment_actions serial_number with

591: lv_sep_check ||
592: nvl(lv_multi_asg_flag,'N') ||
593: to_char(ln_max_run_aa_id);
594:
595: -- update pay_assignment_actions serial_number with
596: -- runactid.
597:
598: update pay_assignment_actions
599: set serial_number = serialno

Line 705: select pay_assignment_actions_s.nextval

701: end loop; -- c_payment_info
702: close c_payment_info;
703: else
704:
705: select pay_assignment_actions_s.nextval
706: into lockingactid
707: from dual;
708:
709: hr_utility.trace('B4 insact'||to_char(lockingactid) ||','||

Line 723: -- update pay_assignment_actions serial_number with runactid.

719:
720: begin
721: --serialno := 'V'||to_char(runactid);
722: serialno := actiontype || 'NN' || to_char(lockedactid);
723: -- update pay_assignment_actions serial_number with runactid.
724: update pay_assignment_actions
725: set serial_number = serialno
726: where assignment_action_id = lockingactid
727: and tax_unit_id = greid;