206: where LESSOR_ID = p_dup_vendor_id
207: and LESSOR_SITE_ID = p_dup_vendor_site_id;
208:
209: -- **********************************************************
210: -- Updating FA_ASSET_INVOICES : PO_VENDOR_ID
211: -- **********************************************************
212: l_location := 'FA_ASSET_INVOICES';
213: update FA_ASSET_INVOICES
214: set PO_VENDOR_ID = p_vendor_id
208:
209: -- **********************************************************
210: -- Updating FA_ASSET_INVOICES : PO_VENDOR_ID
211: -- **********************************************************
212: l_location := 'FA_ASSET_INVOICES';
213: update FA_ASSET_INVOICES
214: set PO_VENDOR_ID = p_vendor_id
215: where PO_VENDOR_ID = p_dup_vendor_id;
216:
209: -- **********************************************************
210: -- Updating FA_ASSET_INVOICES : PO_VENDOR_ID
211: -- **********************************************************
212: l_location := 'FA_ASSET_INVOICES';
213: update FA_ASSET_INVOICES
214: set PO_VENDOR_ID = p_vendor_id
215: where PO_VENDOR_ID = p_dup_vendor_id;
216:
217: -- **********************************************************