APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_CATEGORY_BOOKS

Line 244: FROM igi_iac_reval_categories rc, igi_iac_category_books cb

240: DECODE(cb.allow_prof_reval_flag,'Y','P')) reval_type,
241: NVL(cb.allow_indexed_reval_flag, 'N')allow_indexed_reval_flag,
242: NVL(cb.allow_prof_reval_flag, 'N')allow_prof_reval_flag,
243: rc.revaluation_id
244: FROM igi_iac_reval_categories rc, igi_iac_category_books cb
245: WHERE rc.category_id = cb.category_id
246: AND rc.book_type_code = cb.book_type_code
247: AND rc.book_type_code = p_book_type_code
248: AND rc.revaluation_id = p_revaluation_id

Line 256: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,

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
258: ) IS
259: SELECT a.asset_id,
260: b.cost

Line 257: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE

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
258: ) IS
259: SELECT a.asset_id,
260: b.cost
261: FROM fa_additions a,