APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_SS_APPL_TYP

Line 565: FROM igs_ad_ss_appl_typ

561: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
562: )
563: IS
564: SELECT admission_application_type
565: FROM igs_ad_ss_appl_typ
566: WHERE admission_cat = cp_adm_cat
567: AND S_admission_process_type = cp_s_adm_prc_typ
568: AND System_default = 'Y'
569: AND NVL(closed_ind, 'N') <> 'Y';