72: and p_vendor_id is not null Then
73:
74: SAVEPOINT jl_vendor_merge;
75:
76: -- Update JL_ZZ_AP_SUPP_AWT_TYPES - vendor_id
77: Update JL_ZZ_AP_SUPP_AWT_TYPES
78: set vendor_id = p_vendor_id
79: where vendor_id = p_dup_vendor_id;
80:
73:
74: SAVEPOINT jl_vendor_merge;
75:
76: -- Update JL_ZZ_AP_SUPP_AWT_TYPES - vendor_id
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