75:
76: --get next sequential number
77: SELECT IEM_DP_ACCT_STATUS_S1.nextval
78: INTO l_seq_id
79: FROM dual;
80:
81: INSERT INTO IEM_DP_ACCT_STATUS
82: (
83: DP_ACCT_STATUS_ID,
440:
441: --get next sequential number
442: SELECT IEM_DP_PROCESS_STATUS_S1.nextval
443: INTO l_seq_id
444: FROM dual;
445:
446: INSERT INTO IEM_DP_PROCESS_STATUS
447: (
448: DP_PROCESS_STATUS_ID,