1059: SELECT party_site_id, party_id
1060: INTO v_PartySiteID, v_party_id
1061: FROM ecx_tp_headers
1062: WHERE tp_header_id IN (SELECT DISTINCT tp_header_id 1063: FROM ecx_tp_details 1064: WHERE source_tp_location_code = v_SourceTPLocCode
1065: AND ext_process_id = v_ExtProcessID);
1066: --
1067: IF (l_debug <> -1) THEN