DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI dependencies on IGS_FI_FEE_CAT_MAP

Line 830: FROM IGS_FI_FEE_CAT_MAP

826: course_cd = p_course_cd;
827: CURSOR c_fcm (
828: cp_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE) IS
829: SELECT 'x'
830: FROM IGS_FI_FEE_CAT_MAP
831: WHERE admission_cat = p_admission_cat AND
832: fee_cat = cp_fee_cat;
833:
834: CURSOR c_ccm (

Line 2695: cp_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE,

2691: RETURN BOOLEAN AS
2692: BEGIN -- admp_val_acai_fc
2693: DECLARE
2694: CURSOR c_fcm(
2695: cp_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE,
2696: cp_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE) IS
2697: SELECT 'x'
2698: FROM IGS_FI_FEE_CAT_MAP
2699: WHERE fee_cat = cp_fee_cat AND

Line 2696: cp_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE) IS

2692: BEGIN -- admp_val_acai_fc
2693: DECLARE
2694: CURSOR c_fcm(
2695: cp_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE,
2696: cp_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE) IS
2697: SELECT 'x'
2698: FROM IGS_FI_FEE_CAT_MAP
2699: WHERE fee_cat = cp_fee_cat AND
2700: admission_cat = cp_admission_cat;

Line 2698: FROM IGS_FI_FEE_CAT_MAP

2694: CURSOR c_fcm(
2695: cp_admission_cat IGS_FI_FEE_CAT_MAP.admission_cat%TYPE,
2696: cp_fee_cat IGS_FI_FEE_CAT_MAP.fee_cat%TYPE) IS
2697: SELECT 'x'
2698: FROM IGS_FI_FEE_CAT_MAP
2699: WHERE fee_cat = cp_fee_cat AND
2700: admission_cat = cp_admission_cat;
2701: v_fcm_rec c_fcm%ROWTYPE;
2702: v_message_name VARCHAR2(30);