DBA Data[Home] [Help]

APPS.CLN_PO_SYNC_CAT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 200: FROM po_vendor_sites_all

196: END IF;
197:
198: SELECT org_id
199: INTO l_org_id
200: FROM po_vendor_sites_all
201: WHERE vendor_site_id = p_tp_site_id;
202:
203:
204: IF (l_Debug_Level <= 1) THEN

Line 1307: FROM ecx_tp_headers eth, po_vendor_sites_all povs

1303:
1304: -- The following statement should not throw any exception
1305: SELECT org_id
1306: INTO l_org_id
1307: FROM ecx_tp_headers eth, po_vendor_sites_all povs
1308: WHERE eth.tp_header_id = l_tp_header_id
1309: and povs.vendor_site_id = eth.party_site_id;
1310:
1311: IF (l_Debug_Level <= 1) THEN