APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_ADDITIONS

Line 203: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE

199: l_current_cost igi_iac_reval_asset_rules.new_cost%TYPE;
200: l_cost BOOLEAN;
201: l_adjusted_cost NUMBER;
202:
203: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE
204: INDEX BY BINARY_INTEGER;
205:
206: TYPE cost_tbl_type IS TABLE OF FA_BOOKS.COST%TYPE
207: INDEX BY BINARY_INTEGER;

Line 230: CURSOR c_get_assets(p_cat_id IN fa_additions.asset_category_id%TYPE,

226: AND rc.select_category ='Y'
227: AND ( NVL(cb.allow_indexed_reval_flag,'N') = 'Y'
228: OR NVL(cb.allow_prof_reval_flag, 'N')='Y');
229:
230: CURSOR c_get_assets(p_cat_id IN fa_additions.asset_category_id%TYPE,
231: p_period_counter IN NUMBER,
232: p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
233: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,
234: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE

Line 238: FROM fa_additions a,

234: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE
235: ) IS
236: SELECT a.asset_id,
237: b.cost
238: FROM fa_additions a,
239: fa_books b
240: WHERE a.asset_id = b.asset_id
241: AND b.book_type_code = p_book_type_code
242: AND a.asset_category_id = p_cat_id