eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_EFC_SUBF dependencies on IGF_FC_GEN_TAX_RTS

Line 130: FROM igf_fc_gen_tax_rts gtxrts

126:
127: -- Cursor to calculate Social Security Tax for Father and Mother.
128: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.m_income_work%TYPE) IS
129: SELECT tax_rate, amount, tax_rate_excess, amount_excess
130: FROM igf_fc_gen_tax_rts gtxrts
131: WHERE gtxrts.table_code = 'A2'
132: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
133: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
134:

Line 567: FROM igf_fc_gen_tax_rts gtxrts

563:
564: -- Cursor to calculate Adjusted Net worth of Business/farm
565: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS
566: SELECT tax_rate, amount, tax_rate_excess, amount_excess
567: FROM igf_fc_gen_tax_rts gtxrts
568: WHERE gtxrts.table_code = 'A4'
569: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
570: AND (cp_business_networth BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
571:

Line 727: FROM igf_fc_gen_tax_rts gtxrts

723:
724: -- Cursor to calculate Parents Contribution from AAI
725: CURSOR p_cont_aai_cur(cp_p_aai NUMBER) IS
726: SELECT tax_rate, amount, tax_rate_excess, amount_excess
727: FROM igf_fc_gen_tax_rts gtxrts
728: WHERE gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
729: AND gtxrts.table_code = 'A6'
730: AND (cp_p_aai BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
731:

Line 907: FROM igf_fc_gen_tax_rts gtxrts

903: -- Cursor to calculate Social Security Tax for Father and Mother.
904:
905: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.m_income_work%TYPE) IS
906: SELECT tax_rate, amount, tax_rate_excess, amount_excess
907: FROM igf_fc_gen_tax_rts gtxrts
908: WHERE gtxrts.table_code = 'A2'
909: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
910: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
911:

Line 1346: FROM igf_fc_gen_tax_rts gtxrts

1342:
1343: -- Cursor to calculate Parents Contribution from AAI
1344: CURSOR p_cont_aai_cur(cp_p_aai NUMBER) IS
1345: SELECT tax_rate, amount, tax_rate_excess, amount_excess
1346: FROM igf_fc_gen_tax_rts gtxrts
1347: WHERE gtxrts.table_code = 'A6'
1348: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
1349: AND (cp_p_aai BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
1350:

Line 1542: FROM igf_fc_gen_tax_rts gtxrts

1538:
1539: -- Cursor to calculate Social Security Tax for Student and Spouse.
1540: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.s_income_from_work%TYPE) IS
1541: SELECT tax_rate, amount, tax_rate_excess, amount_excess
1542: FROM igf_fc_gen_tax_rts gtxrts
1543: WHERE gtxrts.table_code = 'B2'
1544: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
1545: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
1546:

Line 1890: FROM igf_fc_gen_tax_rts gtxrts

1886: -- Cursor to calculate Adjusted Net worth of Business/farm
1887:
1888: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS
1889: SELECT tax_rate, amount, tax_rate_excess, amount_excess
1890: FROM igf_fc_gen_tax_rts gtxrts
1891: WHERE gtxrts.table_code = 'B3' --gmuralid Table code i think needs to be B3, it was A4
1892: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
1893: AND (cp_business_networth BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
1894:

Line 2202: FROM igf_fc_gen_tax_rts gtxrts

2198:
2199: -- Cursor to calculate Social Security Tax for Student and Spouse.(Use of table A2 instead C2 as both have same Information)
2200: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.s_income_from_work%TYPE) IS
2201: SELECT tax_rate, amount, tax_rate_excess, amount_excess
2202: FROM igf_fc_gen_tax_rts gtxrts
2203: WHERE gtxrts.table_code = 'C2'
2204: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
2205: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
2206:

Line 2543: FROM igf_fc_gen_tax_rts gtxrts

2539:
2540: -- Cursor to calculate Adjusted Net worth of Business/farm(Using the A4 instead of C4 as both contains the same Information)
2541: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS
2542: SELECT tax_rate, amount, tax_rate_excess, amount_excess
2543: FROM igf_fc_gen_tax_rts gtxrts
2544: WHERE gtxrts.table_code = 'C4'
2545: AND gtxrts.s_award_year = igf_ap_efc_calc.p_sys_award_year
2546: AND (cp_business_networth BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
2547:

Line 2711: FROM igf_fc_gen_tax_rts gtxrts

2707:
2708: -- Cursor to calculate Student's Contribution from AAI
2709: CURSOR cont_aai_cur(cp_aai NUMBER) IS
2710: SELECT tax_rate, amount, tax_rate_excess, amount_excess
2711: FROM igf_fc_gen_tax_rts gtxrts
2712: WHERE gtxrts.table_code = 'C6'
2713: AND gtxrts.s_award_year= igf_ap_efc_calc.p_sys_award_year
2714: AND (cp_aai BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
2715: