APPS.IGS_FI_VAL_CFAR dependencies on IGS_FI_F_CAT_FEE_LBL

Line 47: igs_fi_f_cat_fee_lbl fcfl,

43: WHERE ft.fee_type = p_fee_type;
44: CURSOR c_sca IS
45: SELECT 'X'
46: FROM igs_en_stdnt_ps_att sca,
47: igs_fi_f_cat_fee_lbl fcfl,
48: igs_fi_fee_str_stat fsst
49: WHERE sca.person_id = p_person_id
50: AND sca.course_cd = p_course_cd
51: AND fcfl.fee_type = p_fee_type

Line 58: igs_fi_f_cat_fee_lbl fcfl,

54: AND fsst.s_fee_structure_status = 'ACTIVE'
55: UNION ALL
56: SELECT 'X'
57: FROM igs_en_spa_terms spa,
58: igs_fi_f_cat_fee_lbl fcfl,
59: igs_fi_fee_str_stat fsst
60: WHERE spa.person_id = p_person_id
61: AND spa.program_cd = p_course_cd
62: AND fcfl.fee_type = p_fee_type