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_LOOKUPS_VIEW

Line 104: l_state igf_lookups_view.lookup_code%TYPE;

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;
108: l_ipa NUMBER;

Line 112: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

108: l_ipa NUMBER;
109: l_eea NUMBER;
110:
111: -- Cursor to find the Valid State
112: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
113: SELECT lookup_code
114: FROM igf_lookups_view
115: WHERE lookup_type = 'IGF_AP_STATE_CODES'
116: AND lookup_code = cp_state;

Line 114: FROM igf_lookups_view

110:
111: -- Cursor to find the Valid State
112: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
113: SELECT lookup_code
114: FROM igf_lookups_view
115: WHERE lookup_type = 'IGF_AP_STATE_CODES'
116: AND lookup_code = cp_state;
117:
118: -- Cursor to calculate State and other tax allowance

Line 119: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

115: WHERE lookup_type = 'IGF_AP_STATE_CODES'
116: AND lookup_code = cp_state;
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)

Line 881: l_state igf_lookups_view.lookup_code%TYPE;

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;
885: l_p_aai NUMBER;

Line 889: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

885: l_p_aai NUMBER;
886: l_state_cd VARCHAR2(30);
887:
888: -- Cursor to find the Valid State
889: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
890: SELECT lookup_code
891: FROM igf_lookups_view
892: WHERE lookup_type = 'IGF_AP_STATE_CODES'
893: AND lookup_code = cp_state;

Line 891: FROM igf_lookups_view

887:
888: -- Cursor to find the Valid State
889: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
890: SELECT lookup_code
891: FROM igf_lookups_view
892: WHERE lookup_type = 'IGF_AP_STATE_CODES'
893: AND lookup_code = cp_state;
894:
895: -- Cursor to calculate State and other tax allowance

Line 896: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

892: WHERE lookup_type = 'IGF_AP_STATE_CODES'
893: AND lookup_code = cp_state;
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'

Line 1516: l_state igf_lookups_view.lookup_code%TYPE;

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;
1520: l_ipa NUMBER;

Line 1525: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

1521: l_eea NUMBER;
1522: l_state_cd VARCHAR2(30);
1523:
1524: -- Cursor to find the Valid State
1525: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
1526: SELECT lookup_code
1527: FROM igf_lookups_view
1528: WHERE lookup_type = 'IGF_AP_STATE_CODES'
1529: AND lookup_code = cp_state;

Line 1527: FROM igf_lookups_view

1523:
1524: -- Cursor to find the Valid State
1525: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
1526: SELECT lookup_code
1527: FROM igf_lookups_view
1528: WHERE lookup_type = 'IGF_AP_STATE_CODES'
1529: AND lookup_code = cp_state;
1530:
1531: -- Cursor to calculate State and other tax allowance

Line 1532: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

1528: WHERE lookup_type = 'IGF_AP_STATE_CODES'
1529: AND lookup_code = cp_state;
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

Line 2176: l_state igf_lookups_view.lookup_code%TYPE;

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;
2180: l_ipa NUMBER;

Line 2184: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

2180: l_ipa NUMBER;
2181: l_eea NUMBER;
2182:
2183: -- Cursor to find the Valid State
2184: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
2185: SELECT lookup_code
2186: FROM igf_lookups_view
2187: WHERE lookup_type = 'IGF_AP_STATE_CODES'
2188: AND lookup_code = cp_state;

Line 2186: FROM igf_lookups_view

2182:
2183: -- Cursor to find the Valid State
2184: CURSOR state_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS
2185: SELECT lookup_code
2186: FROM igf_lookups_view
2187: WHERE lookup_type = 'IGF_AP_STATE_CODES'
2188: AND lookup_code = cp_state;
2189:
2190: -- Cursor to calculate State and other tax allowance(Use of table A1 instead C1 as both have same Information)

Line 2191: CURSOR state_allow_cur(cp_state igf_lookups_view.lookup_code%TYPE) IS

2187: WHERE lookup_type = 'IGF_AP_STATE_CODES'
2188: AND lookup_code = cp_state;
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