APPS.IGF_GR_PELL_CALC dependencies on IGF_GR_REG_AMTS

Line 39: | rasahoo 28-May-2004 Bug# 4396459 Repalced the table refference igf_gr_pell_rng_amt with igf_gr_reg_amts and|

35: | museshad 12-Sep-2005 Build FA 157. Added the procedure round_term_disbursements to implement Pell |
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 |

Line 1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,

1211:
1212: CURSOR c_pell_rng(
1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,
1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1218: ) IS
1219: SELECT crngd.pell_amount amount

Line 1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,

1212: CURSOR c_pell_rng(
1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,
1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1218: ) IS
1219: SELECT crngd.pell_amount amount
1220: FROM igf_gr_reg_amts crngd,

Line 1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE

1213: l_ci_cal_type igf_aw_fund_mast.ci_cal_type%TYPE,
1214: l_ci_sequence_number igf_aw_fund_mast.ci_sequence_number%TYPE,
1215: l_coa igf_gr_reg_amts.coa_range_start%TYPE,
1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1218: ) IS
1219: SELECT crngd.pell_amount amount
1220: FROM igf_gr_reg_amts crngd,
1221: igf_ap_batch_aw_map_all batch

Line 1220: FROM igf_gr_reg_amts crngd,

1216: l_efc igf_gr_reg_amts.efc_range_start%TYPE,
1217: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%TYPE
1218: ) IS
1219: SELECT crngd.pell_amount amount
1220: FROM igf_gr_reg_amts crngd,
1221: igf_ap_batch_aw_map_all batch
1222: WHERE crngd.enrollment_stat_code = l_enrl_stat
1223: AND batch.ci_cal_type = l_ci_cal_type
1224: AND batch.ci_sequence_number = l_ci_sequence_number

Line 1241: l_efc igf_gr_reg_amts.efc_range_start%TYPE,

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
1245: FROM igf_gr_alt_amts alt,

Line 1242: l_enrl_stat igf_gr_reg_amts.enrollment_stat_code%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
1245: FROM igf_gr_alt_amts alt,
1246: igf_ap_batch_aw_map_all batch