APPS.IGF_AP_EFC_SUBF dependencies on IGF_FC_EFC_FRM_A

Line 148: FROM igf_fc_efc_frm_a efca

144:
145: -- Cursor to calculate Employment Expense Allowance:
146: CURSOR eea_cur IS
147: SELECT empl_exp_allowance_rate1, empl_exp_allowance_amount1,empl_exp_allowance_rate2, empl_exp_allowance_amount2
148: FROM igf_fc_efc_frm_a efca
149: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
150:
151: state_rec state_cur%ROWTYPE;
152: state_allow_rec state_allow_cur%ROWTYPE;

Line 553: FROM igf_fc_efc_frm_a efca

549:
550: -- Cursor to find the Setting for Formula A
551: CURSOR efcA_cur IS
552: SELECT A5_default_age, parent_asset_conv_rate
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

Line 915: FROM igf_fc_efc_frm_a efca

911:
912: -- Cursor to calculate Income Protection Allowance
913: CURSOR ipa_cur IS
914: SELECT stud_inc_prot_allowance
915: FROM igf_fc_efc_frm_a efca
916: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
917:
918: state_rec state_cur%ROWTYPE;
919: state_allow_rec state_allow_cur%ROWTYPE;

Line 1099: FROM igf_fc_efc_frm_a efca

1095:
1096: -- Cursor to Find the Default Setting for Formula A
1097: CURSOR efcA_cur IS
1098: SELECT stud_available_income
1099: FROM igf_fc_efc_frm_a efca
1100: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1101: efcA_rec efcA_cur%ROWTYPE;
1102:
1103: BEGIN

Line 1157: FROM igf_fc_efc_frm_a efca

1153:
1154: -- Cursor to find the Default Setting for Formula A
1155: CURSOR efcA_cur IS
1156: SELECT stud_asset_assessment_rate
1157: FROM igf_fc_efc_frm_a efca
1158: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1159:
1160: efcA_rec efcA_cur%ROWTYPE;
1161:

Line 1339: FROM igf_fc_efc_frm_a efca

1335:
1336: -- Cursor to find the Default Setting for Formula A
1337: CURSOR efcA_cur IS
1338: SELECT income_protection_diff_9
1339: FROM igf_fc_efc_frm_a efca
1340: WHERE efca.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1341:
1342:
1343: -- Cursor to calculate Parents Contribution from AAI