APPS.PER_ASS_STATUSES_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES_S

Line 66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval

62: select max(ASSIGNMENT_STATUS_TYPE_ID)
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

Line 628: update PER_ASSIGNMENT_STATUS_TYPES set

624: -- is not changed when updating the record.
625:
626: if X_BUSINESS_GROUP_ID is not null then
627:
628: update PER_ASSIGNMENT_STATUS_TYPES set
629: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
630: LEGISLATION_CODE = X_LEGISLATION_CODE,
631: USER_STATUS = X_USER_STATUS, -- Bug 2731841
632: ACTIVE_FLAG = X_ACTIVE_FLAG,

Line 644: update PER_ASSIGNMENT_STATUS_TYPES set

640: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
641:
642: else
643:
644: update PER_ASSIGNMENT_STATUS_TYPES set
645: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
646: LEGISLATION_CODE = X_LEGISLATION_CODE,
647: -- USER_STATUS = X_USER_STATUS, -- Bug 2731841
648: ACTIVE_FLAG = X_ACTIVE_FLAG,