APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_TR_TYPE_ALL

Line 460: SELECT 1 FROM IGS_AD_PRCS_CAT_STEP APCS , IGS_TR_TYPE_ALL TRT

456: WHERE person_id = p_person_id AND
457: admission_appl_number = p_admission_application_number;
458:
459: CURSOR c_trk_exists(p_adm_cat VARCHAR2, p_adm_prc_typ VARCHAR2) IS
460: SELECT 1 FROM IGS_AD_PRCS_CAT_STEP APCS , IGS_TR_TYPE_ALL TRT
461: WHERE
462: APCS.S_ADMISSION_STEP_TYPE = TRT.TRACKING_TYPE AND
463: APCS.STEP_GROUP_TYPE = 'TRACK' AND
464: TRT.S_TRACKING_TYPE IS NOT NULL