APPS.IGS_PS_USEC_OCCURS_PKG dependencies on DUAL

Line 1075: FROM dual;

1071: SELECT
1072: igs_ps_usec_occurs_s.nextval
1073: INTO
1074: x_UNIT_SECTION_OCCURRENCE_ID
1075: FROM dual;
1076: Before_DML(
1077: p_action=>'INSERT',
1078: x_rowid=>X_ROWID,
1079: x_unit_section_occurrence_id=>X_UNIT_SECTION_OCCURRENCE_ID,

Line 1791: ERROR_TEXT = (SELECT DECODE(NEW_REFERENCES.SCHEDULE_STATUS,'ERROR',NEW_REFERENCES.ERROR_TEXT,NULL) FROM DUAL),

1787: ATTRIBUTE17 = NEW_REFERENCES.ATTRIBUTE17,
1788: ATTRIBUTE18 = NEW_REFERENCES.ATTRIBUTE18,
1789: ATTRIBUTE19 = NEW_REFERENCES.ATTRIBUTE19,
1790: ATTRIBUTE20 = NEW_REFERENCES.ATTRIBUTE20,
1791: ERROR_TEXT = (SELECT DECODE(NEW_REFERENCES.SCHEDULE_STATUS,'ERROR',NEW_REFERENCES.ERROR_TEXT,NULL) FROM DUAL),
1792: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
1793: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1794: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
1795: REQUEST_ID = X_REQUEST_ID,