APPS.IGI_IMP_IAC_PURGE_IAC_PKG dependencies on IGI_IAC_REVALUATIONS

Line 220: p_string => 'Deleting igi_iac_revaluations ...');

216: p_string => SQL%rowcount || ' rows deleted.');
217:
218: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
219: p_full_path => l_path_name,
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

Line 222: Delete igi_iac_revaluations r

218: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
219: p_full_path => l_path_name,
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) );