APPS.ECX_DOCUMENT dependencies on ECX_TRANSACTIONS

Line 96: ecx_transactions et,

92: into i_party_id,
93: i_party_site_id,
94: i_confirmation
95: from ecx_ext_processes eep,
96: ecx_transactions et,
97: ecx_standards es,
98: ecx_tp_headers eth,
99: ecx_tp_details etd
100: where et.transaction_type = p_transaction_type

Line 334: from ecx_transactions

330: Begin
331: /* Added check for party type for bug #2183619 */
332: select transaction_id
333: into i_transaction_id
334: from ecx_transactions
335: where transaction_type = i_transaction_type
336: and transaction_subtype = i_transaction_subtype
337: and (i_party_type is null or party_type = i_party_type);
338: Exception

Line 396: ecx_transactions et,

392: ecx_utils.g_tp_dtl_id
393: from ecx_tp_details etd,
394: ecx_tp_headers eth,
395: ecx_ext_processes eep,
396: ecx_transactions et,
397: ecx_standards es,
398: ecx_mappings em
399: where ( eth.party_id = i_party_id or i_party_id is null )
400: and eth.party_site_id = i_party_site_id

Line 2062: ecx_transactions et,

2058: select etd.confirmation into o_confirmation
2059: from ecx_tp_details etd,
2060: ecx_tp_headers eth,
2061: ecx_ext_processes eep,
2062: ecx_transactions et,
2063: ecx_standards es,
2064: ecx_mappings em
2065: where ( eth.party_id = i_party_id or i_party_id is null )
2066: and eth.party_site_id = i_party_site_id