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
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: