1057: END IF;
1058: --
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);