APPS.IGI_IAC_REVAL_CONCURRENT dependencies on IGI_IAC_REVAL_CATEGORIES

Line 136: from igi_iac_reval_categories

132: cursor c_reval_categories (cp_revaluation_id in number
133: , cp_book_type_code in varchar2
134: ) is
135: select category_id
136: from igi_iac_reval_categories
137: where revaluation_id = cp_revaluation_id
138: and book_type_code = cp_book_type_code
139: and nvl(select_category,'X') = 'Y';
140:

Line 402: from igi_iac_reval_categories

398: cursor c_reval_categories (cp_revaluation_id in number
399: , cp_book_type_code in varchar2
400: ) is
401: select category_id
402: from igi_iac_reval_categories
403: where revaluation_id = cp_revaluation_id
404: and book_type_code = cp_book_type_code
405: and nvl(select_category,'X') = 'Y'
406: ;