APPS.CLN_NTFYINVC_PKG dependencies on ECX_TP_HEADERS

Line 151: FROM ecx_tp_headers

147: --this query return the corresponding Trading Partner values for an Internal Control Number.
148: -- If it raises any exception then its Unexpected error, caught in the caller Procedure
149: SELECT party_id, party_site_id, party_type
150: INTO l_party_id,l_party_site_id,l_party_type
151: FROM ecx_tp_headers
152: WHERE tp_header_id = p_tp_header_id;
153:
154: IF (l_debug_level <= 1) THEN
155: cln_debug_pub.Add('Obtained party type:'|| l_party_type ,1);

Line 1150: FROM ECX_TP_HEADERS

1146: BEGIN
1147:
1148: SELECT PARTY_ID, PARTY_SITE_ID,PARTY_TYPE
1149: INTO l_party_id, l_party_site_id, l_party_type
1150: FROM ECX_TP_HEADERS
1151: WHERE TP_HEADER_ID = l_sender_header_id ;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN