[Home] [Help]
543: l_adj_business_networth NUMBER;
544: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
545: l_net_worth NUMBER;
546: l_age_parent NUMBER;
547: l_edu_sav_assets igf_fc_ast_pc_dt.parent2_allowance%TYPE;
548: l_d_net_worth NUMBER;
549:
550: -- Cursor to find the Setting for Formula A
551: CURSOR efcA_cur IS
553: FROM igf_fc_efc_frm_a efca
554: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
555:
556: -- Cursor to calculate Asset Protection Allowance
557: CURSOR asset_cur(cp_age_older_parent igf_fc_ast_pc_dt.older_parent_age%TYPE) IS
558: SELECT parent1_allowance, parent2_allowance
559: FROM igf_fc_ast_pc_dt apdt
560: WHERE apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year
561: AND apdt.table_code = 'A5'
555:
556: -- Cursor to calculate Asset Protection Allowance
557: CURSOR asset_cur(cp_age_older_parent igf_fc_ast_pc_dt.older_parent_age%TYPE) IS
558: SELECT parent1_allowance, parent2_allowance
559: FROM igf_fc_ast_pc_dt apdt
560: WHERE apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year
561: AND apdt.table_code = 'A5'
562: AND apdt.older_parent_age = cp_age_older_parent;
563:
1865: l_adj_business_networth NUMBER;
1866: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
1867: l_net_worth NUMBER;
1868: l_age_student NUMBER;
1869: l_asset_pro_allow igf_fc_ast_pc_dt.parent2_allowance%TYPE;
1870: l_d_net_worth NUMBER;
1871:
1872: -- Cursor to find the Setting for Formula B
1873: CURSOR efcB_cur IS
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
1880: SELECT parent1_allowance, parent2_allowance
1881: FROM igf_fc_ast_pc_dt apdt
1882: WHERE apdt.table_code = 'B4' --gmuralid table code I think needs to be B4 , it was A5
1883: AND apdt.older_parent_age = cp_age_student
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
1880: SELECT parent1_allowance, parent2_allowance
1881: FROM igf_fc_ast_pc_dt apdt
1882: WHERE apdt.table_code = 'B4' --gmuralid table code I think needs to be B4 , it was A5
1883: AND apdt.older_parent_age = cp_age_student
1884: AND apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1885:
2519: l_adj_business_networth NUMBER;
2520: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
2521: l_net_worth NUMBER;
2522: l_age_student NUMBER;
2523: l_asset_pro_allow igf_fc_ast_pc_dt.parent2_allowance%TYPE;
2524: l_d_net_worth NUMBER;
2525:
2526: -- Cursor to find the Setting for Formula C
2527: CURSOR efcC_cur IS
2529: FROM igf_fc_efc_frm_c efcc
2530: WHERE efcc.s_award_year = igf_ap_efc_calc.p_sys_award_year;
2531:
2532: -- Cursor to calculate Asset Protection Allowance(Using the A5 instead of C5 as both contains the same Information)
2533: CURSOR asset_cur(cp_age_student igf_fc_ast_pc_dt.older_parent_age%TYPE) IS
2534: SELECT parent1_allowance, parent2_allowance
2535: FROM igf_fc_ast_pc_dt apdt
2536: WHERE apdt.table_code = 'C5'
2537: AND apdt.older_parent_age = cp_age_student
2531:
2532: -- Cursor to calculate Asset Protection Allowance(Using the A5 instead of C5 as both contains the same Information)
2533: CURSOR asset_cur(cp_age_student igf_fc_ast_pc_dt.older_parent_age%TYPE) IS
2534: SELECT parent1_allowance, parent2_allowance
2535: FROM igf_fc_ast_pc_dt apdt
2536: WHERE apdt.table_code = 'C5'
2537: AND apdt.older_parent_age = cp_age_student
2538: AND apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year;
2539: