767: l_v_err_msg fnd_new_messages.message_name%TYPE;
768: l_b_nat_rec BOOLEAN;
769:
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
768: l_b_nat_rec BOOLEAN;
769:
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,
769:
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,