APPS.IGS_AS_GEN_004 dependencies on IGS_AS_MARK_SHEET_GRPSEQNUM_S

Line 817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL

813: FROM igs_as_msht_su_atmpt mssua2
814: WHERE mssua2.sheet_number = cp_ms_mark_sheet
815: AND mssua2.person_id = cp_mssua1_person_id;
816: CURSOR c_get_nxt_seq_no IS
817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
818: FROM DUAL;
819: CURSOR c_get_nxt_grp_seq_no IS
820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
821: FROM DUAL;

Line 820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL

816: CURSOR c_get_nxt_seq_no IS
817: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
818: FROM DUAL;
819: CURSOR c_get_nxt_grp_seq_no IS
820: SELECT igs_as_mark_sheet_grpseqnum_s.NEXTVAL
821: FROM DUAL;
822: ----------------------------------------ASSPL_INS_MSSUA_SORT--------------------
823: -- procedure used to mainly insert student records (orderd by
824: -- PERSON_ID/SURNAME) into MSSUA