APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_REVAL_CATEGORIES

Line 136: p_category_id IN igi_iac_reval_categories.category_id%TYPE,

132: END;
133:
134: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
135: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
136: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
137: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
138: p_exception_type IN VARCHAR2
139: )
140:

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