APPS.IGS_AS_GEN_006 dependencies on DUAL

Line 887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;

883: BEGIN -- assp_ins_aia
884: -- Insert a record into the IGS_AS_ITEM_ASSESSOR table
885: --DECLARE
886: --BEGIN
887: select IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S.NEXTVAL into V_SEQUENCE_NUMBER FROM DUAL;
888: x_rowid := NULL ;
889: IGS_AS_ITEM_ASSESSOR_PKG.INSERT_ROW(
890: X_ROWID => x_rowid,
891: X_ASS_ID => p_ass_id,

Line 1704: FROM dual;

1700: cst_no CONSTANT CHAR := 'N';
1701: v_session_id NUMBER;
1702: CURSOR c_sess_id IS
1703: SELECT userenv('SESSIONID')
1704: FROM dual;
1705: -- Cursor to select teaching periods under the assessment period.
1706: CURSOR c_teach_perd (
1707: cp_ass_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS