APPS.IGF_GR_PELL_CALC dependencies on IGF_GR_ALT_AMTS

Line 40: | Repalced the table refference igf_gr_alt_coa with igf_gr_alt_amts. |

36: | disbursement rounding. |
37: | museshad 13-Jul-2005 Build FA 157. Added the proocedure 'get_key_prog_ver' and other related changes |
38: | relating to deriving anticipated data. |
39: | rasahoo 28-May-2004 Bug# 4396459 Repalced the table refference igf_gr_pell_rng_amt with igf_gr_reg_amts and|
40: | Repalced the table refference igf_gr_alt_coa with igf_gr_alt_amts. |
41: | cdcruz 28-Oct-2004 FA152 BUILD Modified igf_aw_packng_subfns.get_fed_efc() as part of dependency |
42: | sjadhav 15-Oct-2004 Modified get_pell_setup for COD Entity ID |
43: | veramach 12-Dec-2003 Fixed issues with NVL |
44: | sjalasut 10 Dec, 2003 FA132 Changes.Removed get_current_enrl_term |

Line 1239: l_coa igf_gr_alt_amts.coa_range_start%TYPE,

1235:
1236: CURSOR c_alt_pell(
1237: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1238: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1239: l_coa igf_gr_alt_amts.coa_range_start%TYPE,
1240: l_altexp igf_gr_alt_amts.exp_range_start%TYPE,
1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1242: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1243: ) IS

Line 1240: l_altexp igf_gr_alt_amts.exp_range_start%TYPE,

1236: CURSOR c_alt_pell(
1237: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1238: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1239: l_coa igf_gr_alt_amts.coa_range_start%TYPE,
1240: l_altexp igf_gr_alt_amts.exp_range_start%TYPE,
1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1242: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1243: ) IS
1244: SELECT alt.pell_amount amount

Line 1245: FROM igf_gr_alt_amts alt,

1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1242: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1243: ) IS
1244: SELECT alt.pell_amount amount
1245: FROM igf_gr_alt_amts alt,
1246: igf_ap_batch_aw_map_all batch
1247: WHERE alt.enrollment_stat_code = l_enrl_stat
1248: AND alt.sys_awd_yr = batch.sys_award_year
1249: AND batch.ci_cal_type = l_ci_cal_type