APPS.IGS_FI_GEN_004 dependencies on IGS_FI_FEE_AS_RATE

Line 135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,

131: cp_v_s_fee_type1 igs_fi_fee_type.s_fee_type%TYPE,
132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,
135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,
136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_type%TYPE
137: ) IS
138: SELECT fcflv.fee_type fee_type,
139: far.chg_rate chg_rate,

Line 136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_type%TYPE

132: cp_v_s_fee_type2 igs_fi_fee_type.s_fee_type%TYPE,
133: cp_v_s_fee_type3 igs_fi_fee_type.s_fee_type%TYPE,
134: cp_v_chk_spa_liable VARCHAR2,
135: cp_v_s_relation_type1 igs_fi_fee_as_rate.s_relation_type%TYPE,
136: cp_v_s_relation_type2 igs_fi_fee_as_rate.s_relation_type%TYPE
137: ) IS
138: SELECT fcflv.fee_type fee_type,
139: far.chg_rate chg_rate,
140: fcflv.fee_cal_type fee_cal_type,

Line 152: igs_fi_fee_as_rate far,

148: far.attendance_mode chg_rate_attendance_mode
149: FROM igs_en_stdnt_ps_att spa,
150: igs_fi_f_cat_fee_lbl_v fcflv,
151: igs_fi_fee_str_stat fsst,
152: igs_fi_fee_as_rate far,
153: igs_fi_fee_type ft,
154: igs_fi_fee_as_rt cfar
155: WHERE spa.person_id = p_person_id
156: AND spa.course_cd = p_course_cd

Line 215: igs_fi_fee_as_rate far,

211: FROM igs_en_spa_terms spt,
212: igs_en_stdnt_ps_att spa,
213: igs_fi_f_cat_fee_lbl_v fcflv,
214: igs_fi_fee_str_stat fsst,
215: igs_fi_fee_as_rate far,
216: igs_fi_fee_type ft,
217: igs_fi_fee_as_rt cfar
218: WHERE spt.person_id = p_person_id
219: AND spt.program_cd = p_course_cd