DBA Data[Home] [Help]

APPS.M4R_OM_CONF_PKG dependencies on ECX_TP_DETAILS_V

Line 219: from ecx_tp_details_v

215: l_party_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_ID');
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';

Line 310: FROM ecx_tp_details_v

306:
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')