DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_SOURCE_CAT

Line 218: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS

214: l_src_type_id_rec cur_src_type_id%ROWTYPE;
215:
216: --Check whether the Source Category of Academic History is included within the source Type "UCAS PER" or not.
217: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
218: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
219: SELECT 'X'
220: FROM igs_ad_source_cat_v
221: WHERE source_type_id = cp_source_type_id
222: AND category_name = cp_category

Line 220: FROM igs_ad_source_cat_v

216: --Check whether the Source Category of Academic History is included within the source Type "UCAS PER" or not.
217: CURSOR cur_pe_src_cat (cp_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
218: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
219: SELECT 'X'
220: FROM igs_ad_source_cat_v
221: WHERE source_type_id = cp_source_type_id
222: AND category_name = cp_category
223: AND include_ind = 'Y';
224: