APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_AD_SS_APPL_TYP

Line 383: FROM igs_ad_ss_appl_typ

379: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
380: )
381: IS
382: SELECT admission_application_type
383: FROM igs_ad_ss_appl_typ
384: WHERE admission_cat = cp_adm_cat
385: AND S_admission_process_type = cp_s_adm_prc_typ
386: AND System_default = 'Y'
387: AND NVL(closed_ind, 'N') <> 'Y';