APPS.CLN_PO_SYNC_CAT_PKG dependencies on ECX_TP_HEADERS

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

Line 1930: FROM ECX_TP_HEADERS

1926:
1927:
1928: SELECT PARTY_ID, PARTY_SITE_ID
1929: INTO l_tp_id, l_tp_site_id
1930: FROM ECX_TP_HEADERS
1931: WHERE TP_HEADER_ID = p_tp_header_id;
1932:
1933: IF (l_Debug_Level <= 1) THEN
1934: cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);