APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_ADDITIONS

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

222: l_current_cost igi_iac_reval_asset_rules.new_cost%TYPE;
223: l_cost BOOLEAN;
224: l_adjusted_cost NUMBER;
225:
226: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE
227: INDEX BY BINARY_INTEGER;
228:
229: TYPE cost_tbl_type IS TABLE OF FA_BOOKS.COST%TYPE
230: INDEX BY BINARY_INTEGER;

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

249: AND rc.select_category ='Y'
250: AND ( NVL(cb.allow_indexed_reval_flag,'N') = 'Y'
251: OR NVL(cb.allow_prof_reval_flag, 'N')='Y');
252:
253: CURSOR c_get_assets(p_cat_id IN fa_additions.asset_category_id%TYPE,
254: p_period_counter IN NUMBER,
255: p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
256: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,
257: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE

Line 261: FROM fa_additions a,

257: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE
258: ) IS
259: SELECT a.asset_id,
260: b.cost
261: FROM fa_additions a,
262: fa_books b
263: WHERE a.asset_id = b.asset_id
264: AND b.book_type_code = p_book_type_code
265: AND a.asset_category_id = p_cat_id