APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_FI_WAIVER_PGMS

Line 774: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE)

770: --Bug#3392095 - Tuition Waiver, Cursor to obtain the waiver program attributes for the fee, fee cal types combination.
771: CURSOR cur_get_waiver_attr(cp_v_fee_type igs_fi_inv_int_all.fee_type%TYPE,
772: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
773: cp_n_fee_ci_sequence_number igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
774: cp_v_waiver_name igs_fi_waiver_pgms.waiver_name%TYPE)
775: IS
776: SELECT fwp.fee_cal_type,
777: fwp.fee_ci_sequence_number,
778: fwp.waiver_name,

Line 781: FROM igs_fi_waiver_pgms fwp

777: fwp.fee_ci_sequence_number,
778: fwp.waiver_name,
779: fwp.credit_type_id,
780: fwp.target_fee_type
781: FROM igs_fi_waiver_pgms fwp
782: WHERE fwp.adjustment_fee_type = cp_v_fee_type
783: AND fwp.fee_cal_type = cp_v_fee_cal_type
784: AND fwp.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
785: AND fwp.waiver_name = cp_v_waiver_name;