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_AP_ISIR_MATCHED

Line 37: l_adjusted_gross_income igf_ap_isir_matched.p_adjusted_gross_income%TYPE;

33: ||
34: || (reverse chronological order - newest change first)
35: */
36: -- Initialize the local variables with the Global variables.
37: l_adjusted_gross_income igf_ap_isir_matched.p_adjusted_gross_income%TYPE;
38: l_p_inc_work NUMBER;
39: l_tot_tax_inc NUMBER;
40: l_tot_untax_inc NUMBER;
41: l_tot_inc NUMBER;

Line 103: l_p_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;

99: || Who When What
100: || (reverse chronological order - newest change first)
101: */
102:
103: l_p_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;
104: l_state igf_lookups_view.lookup_code%TYPE;
105: l_tax_allowance NUMBER;
106: l_f_sst NUMBER;
107: l_m_sst NUMBER;

Line 128: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.m_income_work%TYPE) IS

124: AND txrng.state_code = cp_state
125: AND txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year;
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

Line 136: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,

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:
135: -- Cursor to calculate Income Protection Allowance
136: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
137: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
138: SELECT ip_allowance_amt
139: FROM igf_fc_inc_prct ipa
140: WHERE ipa.table_code = 'A3'

Line 137: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS

133: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
134:
135: -- Cursor to calculate Income Protection Allowance
136: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
137: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
138: SELECT ip_allowance_amt
139: FROM igf_fc_inc_prct ipa
140: WHERE ipa.table_code = 'A3'
141: AND ipa.s_award_year = igf_ap_efc_calc.p_sys_award_year

Line 541: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;

537: || nsidana 11/20/2003 FA129 EFC updates for 2004-2005.
538: || (reverse chronological order - newest change first)
539:
540: */
541: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
542: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
543: l_adj_business_networth NUMBER;
544: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
545: l_net_worth NUMBER;

Line 542: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;

538: || (reverse chronological order - newest change first)
539:
540: */
541: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
542: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 544: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;

540: */
541: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
542: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 565: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS

561: AND apdt.table_code = 'A5'
562: AND apdt.older_parent_age = cp_age_older_parent;
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

Line 812: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;

808: || (reverse chronological order - newest change first)
809: */
810: -- Initialize the local variables with the Global variables.
811:
812: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;
813: l_s_inc_work NUMBER;
814: l_tot_tax_inc NUMBER;
815: l_tot_untax_inc NUMBER;
816: l_tot_inc NUMBER;

Line 880: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;

876: || (reverse chronological order - newest change first)
877: */
878: -- Initialize the local variables with the Global variables.
879:
880: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;
881: l_state igf_lookups_view.lookup_code%TYPE;
882: l_tax_allowance NUMBER;
883: l_s_sst NUMBER;
884: l_ipa NUMBER;

Line 905: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.m_income_work%TYPE) IS

901: AND txrng.state_code = cp_state;
902:
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

Line 1149: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;

1145: || Change History :
1146: || Who When What
1147: || (reverse chronological order - newest change first)
1148: */
1149: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1150: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
1151: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
1152: l_net_worth NUMBER;
1153:

Line 1150: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;

1146: || Who When What
1147: || (reverse chronological order - newest change first)
1148: */
1149: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1150: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
1151: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
1152: l_net_worth NUMBER;
1153:
1154: -- Cursor to find the Default Setting for Formula A

Line 1151: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;

1147: || (reverse chronological order - newest change first)
1148: */
1149: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1150: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
1151: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
1152: l_net_worth NUMBER;
1153:
1154: -- Cursor to find the Default Setting for Formula A
1155: CURSOR efcA_cur IS

Line 1439: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;

1435: || Who When What
1436: || (reverse chronological order - newest change first)
1437: */
1438:
1439: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;
1440: l_s_inc_work NUMBER;
1441: l_tot_tax_inc NUMBER;
1442: l_tot_untax_inc NUMBER;
1443: l_tot_inc NUMBER;

Line 1515: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;

1511: || Who When What
1512: || (reverse chronological order - newest change first)
1513: */
1514:
1515: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;
1516: l_state igf_lookups_view.lookup_code%TYPE;
1517: l_tax_allowance NUMBER;
1518: l_s_sst NUMBER;
1519: l_spouse_sst NUMBER;

Line 1540: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.s_income_from_work%TYPE) IS

1536: AND txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year
1537: AND txrng.state_code = cp_state;
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

Line 1863: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;

1859: || Who When What
1860: || (reverse chronological order - newest change first)
1861: */
1862:
1863: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1864: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
1865: l_adj_business_networth NUMBER;
1866: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
1867: l_net_worth NUMBER;

Line 1864: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;

1860: || (reverse chronological order - newest change first)
1861: */
1862:
1863: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1864: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 1866: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;

1862:
1863: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
1864: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 1888: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS

1884: AND apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year;
1885:
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

Line 2107: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;

2103: || (reverse chronological order - newest change first)
2104: */
2105: -- Initialize the local variables with the Global variables.
2106:
2107: l_adjusted_gross_income igf_ap_isir_matched.s_adjusted_gross_income%TYPE;
2108: l_s_inc_work NUMBER;
2109: l_tot_tax_inc NUMBER;
2110: l_tot_untax_inc NUMBER;
2111: l_tot_inc NUMBER;

Line 2175: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;

2171: || (reverse chronological order - newest change first)
2172: */
2173: -- Initialize the local variables with the Global variables.
2174:
2175: l_s_taxes_paid igf_ap_isir_matched.p_taxes_paid%TYPE;
2176: l_state igf_lookups_view.lookup_code%TYPE;
2177: l_tax_allowance NUMBER;
2178: l_s_sst NUMBER;
2179: l_spouse_sst NUMBER;

Line 2200: CURSOR sst_cur(cp_inc_work igf_ap_isir_matched.s_income_from_work%TYPE) IS

2196: AND txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year
2197: AND (p_s_inc BETWEEN txrng.income_range_start AND txrng.income_range_end) ;
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

Line 2208: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,

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:
2207: -- Cursor to calculate Income Protection Allowance(Use of table C3 )
2208: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
2209: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
2210: SELECT ip_allowance_amt
2211: FROM igf_fc_inc_prct ipa
2212: WHERE ipa.table_code = 'C3'

Line 2209: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS

2205: AND (cp_inc_work BETWEEN gtxrts.income_range_start AND gtxrts.income_range_end);
2206:
2207: -- Cursor to calculate Income Protection Allowance(Use of table C3 )
2208: CURSOR ipa_cur(cp_num_family_member igf_ap_isir_matched.p_num_family_member%TYPE,
2209: cp_num_in_college igf_ap_isir_matched.p_num_in_college%TYPE) IS
2210: SELECT ip_allowance_amt
2211: FROM igf_fc_inc_prct ipa
2212: WHERE ipa.table_code = 'C3'
2213: AND ipa.people_in_household = cp_num_family_member

Line 2517: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;

2513: || (reverse chronological order - newest change first)
2514: */
2515: -- Initialize the local variables with the Global variables.
2516:
2517: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
2518: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
2519: l_adj_business_networth NUMBER;
2520: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;
2521: l_net_worth NUMBER;

Line 2518: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;

2514: */
2515: -- Initialize the local variables with the Global variables.
2516:
2517: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
2518: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 2520: l_cash_saving igf_ap_isir_matched.p_cash_saving%TYPE;

2516:
2517: l_investment_networth igf_ap_isir_matched.p_investment_networth%TYPE;
2518: l_business_networth igf_ap_isir_matched.p_business_networth%TYPE;
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;

Line 2541: CURSOR business_networth_cur(cp_business_networth igf_ap_isir_matched.p_business_networth%TYPE) IS

2537: AND apdt.older_parent_age = cp_age_student
2538: AND apdt.s_award_year = igf_ap_efc_calc.p_sys_award_year;
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