APPS.IGI_IAC_CREATE_ASSETS dependencies on IGI_IAC_REVAL_CATEGORIES

Line 113: p_category_id IN igi_iac_reval_categories.category_id%TYPE,

109: END;
110:
111: PROCEDURE insert_exceptions(p_revaluation_id IN igi_iac_revaluations.revaluation_id%TYPE,
112: p_asset_id IN igi_iac_reval_asset_rules.asset_id%TYPE,
113: p_category_id IN igi_iac_reval_categories.category_id%TYPE,
114: p_book_type_code IN igi_iac_revaluations.book_type_code%TYPE,
115: p_exception_type IN VARCHAR2
116: )
117:

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