APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_STDNT_ID_S

Line 181: SELECT igs_he_stdnt_id_s.nextval

177: FROM igs_en_stdnt_ps_att
178: WHERE person_id = p_person_id;
179:
180: CURSOR c_sid IS
181: SELECT igs_he_stdnt_id_s.nextval
182: FROM dual;
183:
184: --TO select all the alternate person id's with type in (UCASID,NMASID,SWASID,GTTRID)
185: --Cursor to check number of person id types exisitng .