APPS.IGI_IMP_IAC_PURGE_IAC_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 34: FROM igi_iac_transaction_headers it

30:
31: -- Cursor to fetch the assets from the interface table
32: CURSOR c_txns(cp_book VARCHAR2) IS
33: SELECT 'Y'
34: FROM igi_iac_transaction_headers it
35: WHERE it.book_type_code = cp_book
36: AND it.category_id = nvl(p_Category_id,it.category_id)
37: AND NOT ( nvl(it.transaction_sub_type,'AA') = 'IMPLEMENTATION')
38: AND rownum = 1 ;

Line 204: p_string => 'Deleting igi_iac_transaction_headers ...');

200:
201:
202: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
203: p_full_path => l_path_name,
204: p_string => 'Deleting igi_iac_transaction_headers ...');
205:
206: Delete from igi_iac_transaction_headers t
207: Where t.book_type_code = l_corporate_book
208: and exists ( select i.asset_id

Line 206: Delete from igi_iac_transaction_headers t

202: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
203: p_full_path => l_path_name,
204: p_string => 'Deleting igi_iac_transaction_headers ...');
205:
206: Delete from igi_iac_transaction_headers t
207: Where t.book_type_code = l_corporate_book
208: and exists ( select i.asset_id
209: from igi_imp_iac_interface I
210: where i.book_type_code = p_book_type_code