APPS.IGI_IMP_IAC_PURGE_IAC_PKG dependencies on IGI_IAC_REVAL_CATEGORIES

Line 224: from igi_iac_reval_categories c

220: p_string => 'Deleting igi_iac_revaluations ...');
221:
222: Delete igi_iac_revaluations r
223: where r.revaluation_id in ( select c.revaluation_id
224: from igi_iac_reval_categories c
225: where c.book_type_code = l_corporate_book
226: and category_id = nvl(p_category_id,category_id) );
227:
228: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 234: p_string => 'Deleting igi_iac_reval_categories ...');

230: p_string => SQL%rowcount || ' rows deleted.');
231:
232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,
234: p_string => 'Deleting igi_iac_reval_categories ...');
235:
236: Delete igi_iac_reval_categories c
237: where c.book_type_code = l_corporate_book
238: and c.category_id = nvl(p_category_id,c.category_id) ;

Line 236: Delete igi_iac_reval_categories c

232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
233: p_full_path => l_path_name,
234: p_string => 'Deleting igi_iac_reval_categories ...');
235:
236: Delete igi_iac_reval_categories c
237: where c.book_type_code = l_corporate_book
238: and c.category_id = nvl(p_category_id,c.category_id) ;
239:
240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,