[Home] [Help]
511: serial_no varchar2 default null) return number is
512: action_id number(16);
513: begin
514: --
515: select pay_assignment_actions_s.nextval
516: into action_id
517: from dual;
518: --
519: insert into pay_assignment_actions(
515: select pay_assignment_actions_s.nextval
516: into action_id
517: from dual;
518: --
519: insert into pay_assignment_actions(
520: assignment_action_id,
521: assignment_id,
522: payroll_action_id,
523: action_status,