DBA Data[Home] [Help]

APPS.IGS_FI_VAL_CFAR dependencies on IGS_FI_FEE_STR_STAT

Line 48: igs_fi_fee_str_stat fsst

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
52: AND fcfl.fee_cat = sca.fee_cat

Line 59: igs_fi_fee_str_stat fsst

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
63: AND fcfl.fee_cat = spa.fee_cat