APPS.POS_IMP_SUPP_PKG dependencies on AP_SUP_SITE_CONTACT_INT

Line 188: FROM ap_sup_site_contact_int INT

184: /*AND int.source_system = p_original_system*/
185: ;
186: SELECT COUNT(int.sdh_batch_id)
187: INTO l_sup_contact_in_batch
188: FROM ap_sup_site_contact_int INT
189: WHERE int.sdh_batch_id = p_batch_id
190: /*AND int.source_system = p_original_system*/
191: ;
192: SELECT COUNT(int.sdh_batch_id)

Line 533: DELETE ap_sup_site_contact_int WHERE sdh_batch_id = p_batch_id;

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;
535:
536: DELETE pos_product_service_int WHERE sdh_batch_id = p_batch_id;
537: COMMIT;