89: Update JL_ZZ_AP_SUPP_AWT_TYPES
90: set vendor_id = p_vendor_id
91: where vendor_id = p_dup_vendor_id;
92:
93: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
94: Update JL_BR_AP_COLLECTION_DOCS_ALL
95: set vendor_id = p_vendor_id
96: where vendor_id = p_dup_vendor_id;
97:
90: set vendor_id = p_vendor_id
91: where vendor_id = p_dup_vendor_id;
92:
93: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
94: Update JL_BR_AP_COLLECTION_DOCS_ALL
95: set vendor_id = p_vendor_id
96: where vendor_id = p_dup_vendor_id;
97:
98: -- Update JL_BR_AP_CONSOLID_INVOICES_ALL - vendor_id
107:
108: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
109: and p_vendor_id is not null and p_vendor_site_id is not null Then
110:
111: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
112: Update JL_BR_AP_COLLECTION_DOCS_ALL
113: set vendor_id = p_vendor_id,
114: vendor_site_id = p_vendor_site_id
115: where vendor_id = p_dup_vendor_id
108: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
109: and p_vendor_id is not null and p_vendor_site_id is not null Then
110:
111: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
112: Update JL_BR_AP_COLLECTION_DOCS_ALL
113: set vendor_id = p_vendor_id,
114: vendor_site_id = p_vendor_site_id
115: where vendor_id = p_dup_vendor_id
116: and vendor_site_id = p_dup_vendor_site_id;