APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_PS_APPL_INST_ALL

Line 258: FROM igs_ad_ps_appl_inst_all

254: CURSOR cur_ad_appl_inst (p_per_id igs_pe_person.person_id%TYPE) IS
255: SELECT admission_appl_number,
256: nominated_course_cd,
257: sequence_number
258: FROM igs_ad_ps_appl_inst_all
259: WHERE person_id = p_per_id;
260:
261: CURSOR cur_he_ad_dtl_all(p_per_id igs_pe_person.person_id%TYPE) IS
262: SELECT COUNT(*)