APPS.AR_BPA_DATASRC_VIEWS_PKG dependencies on AR_BPA_ITEMS_B

Line 279: where item_id in (select item_id from ar_bpa_items_b

275: ) is
276: begin
277: /* First delete from Item table. then delete from the view item GT table */
278: delete from AR_BPA_ITEMS_TL
279: where item_id in (select item_id from ar_bpa_items_b
280: where data_source_id = X_DATA_SOURCE_ID);
281:
282: delete from AR_BPA_ITEMS_B
283: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;

Line 282: delete from AR_BPA_ITEMS_B

278: delete from AR_BPA_ITEMS_TL
279: where item_id in (select item_id from ar_bpa_items_b
280: where data_source_id = X_DATA_SOURCE_ID);
281:
282: delete from AR_BPA_ITEMS_B
283: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;
284:
285: delete from AR_BPA_DATA_SOURCES_TL
286: where DATA_SOURCE_ID = X_DATA_SOURCE_ID;