APPS.CLN_SYNCITEM_PKG dependencies on ECX_TP_HEADERS

Line 252: from ecx_tp_headers eth

248: BEGIN
249:
250: select eth.party_type, eth.party_id, eth.party_site_id
251: INTO l_tr_partner_type, l_tr_partner_id, l_tr_partner_site
252: from ecx_tp_headers eth
253: where eth.tp_header_id = p_tp_header_id;
254:
255: -- this is reqd for setting the view cln_2a12_party_v
256: g_party_id := l_tr_partner_id;

Line 703: from ecx_tp_headers eth, ecx_tp_details etd, ecx_ext_processes eep,

699:
700: -- cursor to hold the list of trading partners to send to
701: CURSOR c_TradingPartners IS
702: select eth.tp_header_id
703: from ecx_tp_headers eth, ecx_tp_details etd, ecx_ext_processes eep,
704: ecx_transactions et, hz_parties hp, hz_party_sites hps, hz_locations hl
705: where eth.tp_header_id = etd.tp_header_id
706: and etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID and eth.party_id = hp.party_id
707: and eth.party_site_id = hps.party_site_id and hps.location_id = hl.location_id

Line 753: from ecx_tp_headers eth

749:
750: -- get parameters for that particular trading partner
751: select eth.party_id, eth.party_site_id
752: into party_id, party_site_id
753: from ecx_tp_headers eth
754: where eth.tp_header_id = l_tp_header_id;
755:
756: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Initialized procedure parameters';
757: if (l_debug_level <= 1) then