91: confirmation
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
391: i_tp_header_id,
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 )
1815: etd.connection_type,
1816: hub_id,
1817: hub_user_id
1818: from ecx_tp_details etd,
1819: ecx_ext_processes eep,
1820: ecx_standards es
1821: where etd.source_tp_location_code = p_party_ext_code
1822: and eep.ext_type = p_ext_type
1823: and eep.ext_subtype = p_ext_subtype
2057:
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 )