DBA Data[Home] [Help]

APPS.M4R_OM_CONF_PKG dependencies on ECX_TP_HEADERS

Line 220: where tp_header_id = (select tp_header_id from ecx_tp_headers

216:
217: select standard_code
218: into l_standard_code
219: from ecx_tp_details_v
220: where tp_header_id = (select tp_header_id from ecx_tp_headers
221: where party_id = l_party_id and
222: party_site_id = l_party_site_id) and
223: transaction_type ='ONT' and transaction_subtype = 'POA';
224:

Line 311: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers

307: BEGIN
308: SELECT standard_code
309: into l_standard
310: FROM ecx_tp_details_v
311: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
312: WHERE party_id = l_tr_partner_id
313: AND party_site_id = l_tr_partner_site
314: AND party_type = 'C')
315: AND transaction_type ='ONT'