APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_SS_APPL_TYP

Line 1001: FROM igs_ad_ss_appl_typ

997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
998: )
999: IS
1000: SELECT admission_application_type
1001: FROM igs_ad_ss_appl_typ
1002: WHERE admission_cat = cp_adm_cat
1003: AND S_admission_process_type = cp_s_adm_prc_typ
1004: AND System_default = 'Y'
1005: AND NVL(closed_ind, 'N') <> 'Y';