APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_FI_FEE_TYPE

Line 3560: FROM igs_fi_fee_type ft, igs_fi_fee_as chg

3556: -- Bug No: 2911678. Replacing the view igs_fi_fee_ass_debt_v with the view igs_fi_fee_as.
3557: -- smaddali modified this cursor for bug#3179544 , filtering based on Submission periods
3558: CURSOR c_fees IS
3559: SELECT SUM(chg.transaction_amount) tuition_fees
3560: FROM igs_fi_fee_type ft, igs_fi_fee_as chg
3561: WHERE ft.s_fee_type = 'TUTNFEE'
3562: AND chg.person_id = p_person_id
3563: AND (chg.course_cd IS NULL OR chg.course_cd = p_course_cd)
3564: AND chg.fee_type = ft.fee_type

Line 3742: igs_fi_fee_type ft

3738: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
3739: IS
3740: SELECT NVL(SUM(inv.invoice_amount),0) invoice_amount
3741: FROM igs_fi_inv_int inv,
3742: igs_fi_fee_type ft
3743: WHERE inv.fee_type = ft.fee_type
3744: AND person_id = p_person_id
3745: AND inv.fee_cal_type = cp_fee_cal_type
3746: AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number