APPS.POS_IMP_SUPP_PKG dependencies on AP_SUPPLIER_SITES_INT

Line 182: FROM ap_supplier_sites_int INT

178: /*AND int.source_system = p_original_system*/
179: ;
180: SELECT COUNT(int.sdh_batch_id)
181: INTO l_supp_sites_in_batch
182: FROM ap_supplier_sites_int INT
183: WHERE int.sdh_batch_id = p_batch_id
184: /*AND int.source_system = p_original_system*/
185: ;
186: SELECT COUNT(int.sdh_batch_id)

Line 530: DELETE ap_supplier_sites_int WHERE sdh_batch_id = p_batch_id;

526:
527: DELETE ap_suppliers_int WHERE sdh_batch_id = p_batch_id;
528: COMMIT;
529:
530: DELETE ap_supplier_sites_int WHERE sdh_batch_id = p_batch_id;
531: COMMIT;
532:
533: DELETE ap_sup_site_contact_int WHERE sdh_batch_id = p_batch_id;
534: COMMIT;