APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_ACADHIS_INT_ALL

Line 294: CURSOR c_stat_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS

290: AND oss_person_id = cp_person_id
291: ORDER BY app.system_code DESC;
292:
293: -- Get the Applicant Statistics interface records whose import has failed
294: CURSOR c_stat_int (cp_interface_id igs_ad_acadhis_int_all.interface_id%TYPE) IS
295: SELECT a.*
296: FROM igs_ad_stat_int_all a
297: WHERE a.interface_id = cp_interface_id
298: AND a.status = '3';