[Home] [Help]
1547: -- Cursor to find the Default values defined for Formula B.
1548: CURSOR efcB_cur IS
1549: SELECT unmarried_stud_ipa_amt, mss_half_time_ipa_amt,married_stud_ipa_amt, unmarried_stud_eea_amt,
1550: married_one_work_eea_amt,married_two_work_eea_rate, married_two_work_eea_amt
1551: FROM igf_fc_efc_frm_b efcb
1552: WHERE efcb.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1553:
1554: state_rec state_cur%ROWTYPE;
1555: state_allow_rec state_allow_cur%ROWTYPE;
1805:
1806: -- Cursor to Find the Default Setting for Formula B
1807: CURSOR efcB_cur IS
1808: SELECT stud_available_income
1809: FROM igf_fc_efc_frm_b efcb
1810: WHERE efcb.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1811:
1812: efcB_rec efcB_cur%ROWTYPE;
1813:
1871:
1872: -- Cursor to find the Setting for Formula B
1873: CURSOR efcB_cur IS
1874: SELECT stud_asset_conv_rate
1875: FROM igf_fc_efc_frm_b efcb
1876: WHERE efcb.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1877:
1878: -- Cursor to calculate Asset Protection Allowance
1879: CURSOR asset_cur(cp_age_student igf_fc_ast_pc_dt.older_parent_age%TYPE) IS