APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PS_OF_OPT_AD_CAT

Line 41: FROM IGS_PS_OF_OPT_AD_CAT

37: v_x VARCHAR2(1) DEFAULT NULL;
38: v_ret_val BOOLEAN DEFAULT TRUE;
39: CURSOR c_cooac IS
40: SELECT admission_cat
41: FROM IGS_PS_OF_OPT_AD_CAT
42: WHERE coo_id = p_coo_id AND
43: system_default_ind = 'Y';
44: CURSOR c_cooac2 IS
45: SELECT 'x'

Line 46: FROM IGS_PS_OF_OPT_AD_CAT

42: WHERE coo_id = p_coo_id AND
43: system_default_ind = 'Y';
44: CURSOR c_cooac2 IS
45: SELECT 'x'
46: FROM IGS_PS_OF_OPT_AD_CAT
47: WHERE coo_id = p_coo_id AND
48: admission_cat = p_admission_cat;
49: BEGIN
50: p_message_name := NULL;