[Home] [Help]
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
1103: AND rt.person_id = cp_n_person_id
1104: AND rt.course_cd = cp_v_course_cd
1105: AND lbl.fee_cat = cp_v_fee_cat