APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_AD_SOURCE_CAT

Line 3102: CURSOR cur_src_included ( cp_source_type_id IGS_AD_SOURCE_CAT.source_type_id%TYPE,

3098:
3099: ***************************************************************** */
3100:
3101: l_dummy VARCHAR2(1);
3102: CURSOR cur_src_included ( cp_source_type_id IGS_AD_SOURCE_CAT.source_type_id%TYPE,
3103: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
3104: SELECT 'X'
3105: FROM IGS_AD_SOURCE_CAT
3106: WHERE source_type_id = cp_source_type_id AND

Line 3103: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS

3099: ***************************************************************** */
3100:
3101: l_dummy VARCHAR2(1);
3102: CURSOR cur_src_included ( cp_source_type_id IGS_AD_SOURCE_CAT.source_type_id%TYPE,
3103: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
3104: SELECT 'X'
3105: FROM IGS_AD_SOURCE_CAT
3106: WHERE source_type_id = cp_source_type_id AND
3107: category_name = cp_category AND

Line 3105: FROM IGS_AD_SOURCE_CAT

3101: l_dummy VARCHAR2(1);
3102: CURSOR cur_src_included ( cp_source_type_id IGS_AD_SOURCE_CAT.source_type_id%TYPE,
3103: cp_category IGS_AD_SOURCE_CAT.category_name%TYPE) IS
3104: SELECT 'X'
3105: FROM IGS_AD_SOURCE_CAT
3106: WHERE source_type_id = cp_source_type_id AND
3107: category_name = cp_category AND
3108: include_ind = 'Y';
3109: