APPS.POS_IMP_SUPP_PKG dependencies on POS_PRODUCT_SERVICE_INT

Line 194: FROM pos_product_service_int INT

190: /*AND int.source_system = p_original_system*/
191: ;
192: SELECT COUNT(int.sdh_batch_id)
193: INTO l_prodserv_in_batch
194: FROM pos_product_service_int INT
195: WHERE int.sdh_batch_id = p_batch_id
196: /*AND int.source_system = p_original_system*/
197: ;
198:

Line 536: DELETE pos_product_service_int WHERE sdh_batch_id = p_batch_id;

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;
538:
539: DELETE pos_business_class_int WHERE sdh_batch_id = p_batch_id;
540: COMMIT;