62: ----------------------------------------------------------------------------------------
63: --
64:
65:
66: l_dl_fee1_staf igf_sl_dl_setup.orig_fee_perct_stafford%TYPE;
67: l_dl_fee1_plus igf_sl_dl_setup.orig_fee_perct_plus%TYPE;
68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%TYPE;
69:
70:
63: --
64:
65:
66: l_dl_fee1_staf igf_sl_dl_setup.orig_fee_perct_stafford%TYPE;
67: l_dl_fee1_plus igf_sl_dl_setup.orig_fee_perct_plus%TYPE;
68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%TYPE;
69:
70:
71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
64:
65:
66: l_dl_fee1_staf igf_sl_dl_setup.orig_fee_perct_stafford%TYPE;
67: l_dl_fee1_plus igf_sl_dl_setup.orig_fee_perct_plus%TYPE;
68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%TYPE;
69:
70:
71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS
76: SELECT orig_fee_perct_stafford,
77: orig_fee_perct_plus,
78: int_rebate
79: FROM igf_sl_dl_setup
80: WHERE ci_cal_type = p_ci_cal_type
81: AND ci_sequence_number = p_ci_seq_num;
82:
83: CURSOR c_get_fed_fund_code (
675: -- This net amount does not include the Fee Paid
676: -----------------------------------------------------------------------------------
677:
678:
679: ln_comb_int_pct igf_sl_dl_setup_all.int_rebate%TYPE;
680: ln_comb_int_amt igf_aw_awd_disb_all.disb_net_amt%TYPE;
681:
682: BEGIN
683: