APPS.IGS_AS_GEN_004 dependencies on DUAL

Line 214: FROM DUAL

210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;
212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'
214: FROM DUAL
215: WHERE EXISTS ( SELECT *
216: FROM igs_as_ins_grd_entry iaige
217: WHERE iaige.keying_time = cp_keying_time
218: AND iaige.keying_who = cp_keying_who);

Line 221: FROM DUAL

217: WHERE iaige.keying_time = cp_keying_time
218: AND iaige.keying_who = cp_keying_who);
219: CURSOR c_chk_mark_sheets (cp_mark_sheet igs_as_mark_sheet.sheet_number%TYPE) IS
220: SELECT 'x'
221: FROM DUAL
222: WHERE EXISTS ( SELECT *
223: FROM igs_as_msht_su_atmpt iamsa
224: WHERE iamsa.sheet_number = cp_mark_sheet);
225: CURSOR c_grd_entry_tmp IS

Line 818: FROM DUAL;

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;
822: ----------------------------------------ASSPL_INS_MSSUA_SORT--------------------

Line 821: FROM DUAL;

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
825: PROCEDURE asspl_ins_mssua_sort (