APPS.CLN_SYNCCTLG_PKG dependencies on ECX_TP_HEADERS

Line 69: from cln_procat_catitem_v cpcv, ecx_tp_headers eth

65:
66: -- cursor to hold the list of items in price list to send
67: CURSOR c_ItemsToSend IS
68: select concatenated_segments
69: from cln_procat_catitem_v cpcv, ecx_tp_headers eth
70: where cpcv.list_header_id=p_list_header_id
71: and cpcv.party_id=eth.party_id
72: and eth.tp_header_id = p_tp_header_id
73: and cpcv.organization_id = l_inv_org_id

Line 132: from ecx_tp_headers eth

128: end if;
129:
130: select eth.party_id, eth.party_site_id
131: into party_id, party_site_id
132: from ecx_tp_headers eth
133: where eth.tp_header_id = p_tp_header_id;
134:
135: if (l_debug_level <= 1) then
136: cln_debug_pub.Add('party_id:' || party_id, 1);