DBA Data[Home] [Help]

APPS.IGF_SL_AWARD dependencies on IGF_SL_DL_SETUP

Line 66: l_dl_fee1_staf igf_sl_dl_setup.orig_fee_perct_stafford%TYPE;

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:

Line 67: l_dl_fee1_plus igf_sl_dl_setup.orig_fee_perct_plus%TYPE;

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;

Line 68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%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;

Line 79: FROM igf_sl_dl_setup

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 (

Line 679: ln_comb_int_pct igf_sl_dl_setup_all.int_rebate%TYPE;

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: