APPS.IGS_AD_GEN_014 dependencies on IGS_AD_QUAL_TYPE

Line 2014: FROM IGS_AD_QUAL_TYPE

2010:
2011: CURSOR c_apc_qual_type (cp_admission_cat IN VARCHAR2, cp_admission_process_type IN VARCHAR2)
2012: IS
2013: SELECT QUALIFYING_TYPE_CODE
2014: FROM IGS_AD_QUAL_TYPE
2015: WHERE ADMISSION_CAT = cp_admission_cat AND S_ADMISSION_PROCESS_TYPE = cp_admission_process_type
2016: AND CLOSED_FLAG = 'N';
2017:
2018: CURSOR c_def_qual_code(cp_qual_type IN VARCHAR2)

Line 2021: WHERE CLASS=cp_qual_type AND CLASS_TYPE_CODE = 'IGS_AD_QUAL_TYPE'

2017:
2018: CURSOR c_def_qual_code(cp_qual_type IN VARCHAR2)
2019: IS
2020: SELECT CODE_ID FROM IGS_AD_CODE_CLASSES
2021: WHERE CLASS=cp_qual_type AND CLASS_TYPE_CODE = 'IGS_AD_QUAL_TYPE'
2022: AND SYSTEM_DEFAULT = 'Y';
2023:
2024: l_def_qual_code IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
2025: