63: from per_assignment_status_types;
64:
65: cursor CSR_SEQUENCE is
66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval
67: from dual;
68: L_BUSINESS_GROUP_ID NUMBER;
69: L_MAX_SEQ NUMBER;
70: begin
71: open CSR_BUSINESS_GROUP (
225: L_ID NUMBER;
226: BEGIN
227: select per_ass_status_type_amends_s.nextval
228: into L_ID
229: from sys.dual;
230: P_ASS_STATUS_TYPE_AMEND_ID := L_ID;
231: insert into per_ass_status_type_amends(
232: ASS_STATUS_TYPE_AMEND_ID,
233: ASSIGNMENT_STATUS_TYPE_ID,