77: Update JL_ZZ_AP_SUPP_AWT_TYPES
78: set vendor_id = p_vendor_id
79: where vendor_id = p_dup_vendor_id;
80:
81: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
82: Update JL_BR_AP_COLLECTION_DOCS_ALL
83: set vendor_id = p_vendor_id
84: where vendor_id = p_dup_vendor_id;
85:
78: set vendor_id = p_vendor_id
79: where vendor_id = p_dup_vendor_id;
80:
81: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
82: Update JL_BR_AP_COLLECTION_DOCS_ALL
83: set vendor_id = p_vendor_id
84: where vendor_id = p_dup_vendor_id;
85:
86: -- Update JL_BR_AP_CONSOLID_INVOICES_ALL - vendor_id
95:
96: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
97: and p_vendor_id is not null and p_vendor_site_id is not null Then
98:
99: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
100: Update JL_BR_AP_COLLECTION_DOCS_ALL
101: set vendor_id = p_vendor_id,
102: vendor_site_id = p_vendor_site_id
103: where vendor_id = p_dup_vendor_id
96: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
97: and p_vendor_id is not null and p_vendor_site_id is not null Then
98:
99: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
100: Update JL_BR_AP_COLLECTION_DOCS_ALL
101: set vendor_id = p_vendor_id,
102: vendor_site_id = p_vendor_site_id
103: where vendor_id = p_dup_vendor_id
104: and vendor_site_id = p_dup_vendor_site_id;