APPS.IGS_FI_GEN_008 dependencies on IGS_FI_FEE_CAT

Line 1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,

1065: PROCEDURE chk_spa_rec_exists(p_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
1066: p_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
1067: p_v_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1068: p_n_load_ci_seq IN igs_ca_inst.sequence_number%TYPE,
1069: p_v_fee_cat IN igs_fi_fee_cat.fee_cat%TYPE,
1070: p_v_status OUT NOCOPY VARCHAR2,
1071: p_v_message OUT NOCOPY VARCHAR2) AS
1072: /***********************************************************************************************
1073: Created By : Amit Gairola

Line 1098: cp_v_fee_cat igs_fi_fee_cat.fee_cat%TYPE) IS

1094:
1095: -- Cursor for checking if Contract Rates exist
1096: CURSOR cur_cntrct_rates(cp_n_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1097: cp_v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1098: cp_v_fee_cat igs_fi_fee_cat.fee_cat%TYPE) IS
1099: SELECT 'x'
1100: FROM igs_fi_f_cat_fee_lbl_all lbl,
1101: igs_fi_fee_as_rt rt
1102: WHERE lbl.fee_type = rt.fee_type