APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_CATEGORY_BOOKS

Line 221: FROM igi_iac_reval_categories rc, igi_iac_category_books cb

217: DECODE(cb.allow_prof_reval_flag,'Y','P')) reval_type,
218: NVL(cb.allow_indexed_reval_flag, 'N')allow_indexed_reval_flag,
219: NVL(cb.allow_prof_reval_flag, 'N')allow_prof_reval_flag,
220: rc.revaluation_id
221: FROM igi_iac_reval_categories rc, igi_iac_category_books cb
222: WHERE rc.category_id = cb.category_id
223: AND rc.book_type_code = cb.book_type_code
224: AND rc.book_type_code = p_book_type_code
225: AND rc.revaluation_id = p_revaluation_id

Line 233: p_allow_indexed IN igi_iac_category_books.allow_indexed_reval_flag%TYPE,

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
235: ) IS
236: SELECT a.asset_id,
237: b.cost

Line 234: p_allow_prof IN igi_iac_category_books.allow_prof_reval_flag%TYPE

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
235: ) IS
236: SELECT a.asset_id,
237: b.cost
238: FROM fa_additions a,