APPS.IGF_AP_EFC_SUBF dependencies on IGF_FC_STATE_TX

Line 121: FROM igf_fc_state_tx txrng

117:
118: -- Cursor to calculate State and other tax allowance
119: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
120: SELECT tax_rate
121: FROM igf_fc_state_tx txrng
122: WHERE txrng.table_code = 'A1'
123: AND (p_p_inc BETWEEN txrng.income_range_start AND txrng.income_range_end)
124: AND txrng.state_code = cp_state
125: AND txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year;

Line 898: FROM igf_fc_state_tx txrng

894:
895: -- Cursor to calculate State and other tax allowance
896: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
897: SELECT tax_rate
898: FROM igf_fc_state_tx txrng
899: WHERE txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year
900: AND txrng.table_code = 'A7'
901: AND txrng.state_code = cp_state;
902:

Line 1534: FROM igf_fc_state_tx txrng

1530:
1531: -- Cursor to calculate State and other tax allowance
1532: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
1533: SELECT tax_rate
1534: FROM igf_fc_state_tx txrng
1535: WHERE txrng.table_code = 'B1'
1536: AND txrng.s_award_year = igf_ap_efc_calc.p_sys_award_year
1537: AND txrng.state_code = cp_state;
1538:

Line 2193: FROM igf_fc_state_tx txrng

2189:
2190: -- Cursor to calculate State and other tax allowance(Use of table A1 instead C1 as both have same Information)
2191: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
2192: SELECT tax_rate
2193: FROM igf_fc_state_tx txrng
2194: WHERE txrng.table_code = 'C1'
2195: AND txrng.state_code = cp_state
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) ;