APPS.OKL_VENDORMERGE_GRP dependencies on OKL_EXT_BILLING_INTF_ALL

Line 472: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor

468: LAST_UPDATE_DATE = l_last_update_date,
469: LAST_UPDATE_LOGIN = l_last_update_login
470: WHERE VENDOR_ID = p_dup_vendor_id;
471:
472: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor
473: UPDATE OKL_EXT_BILLING_INTF_ALL
474: SET TAX_VENDOR_ID = p_vendor_id,
475: LAST_UPDATED_BY = l_last_updated_by,
476: LAST_UPDATE_DATE = l_last_update_date,

Line 473: UPDATE OKL_EXT_BILLING_INTF_ALL

469: LAST_UPDATE_LOGIN = l_last_update_login
470: WHERE VENDOR_ID = p_dup_vendor_id;
471:
472: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor
473: UPDATE OKL_EXT_BILLING_INTF_ALL
474: SET TAX_VENDOR_ID = p_vendor_id,
475: LAST_UPDATED_BY = l_last_updated_by,
476: LAST_UPDATE_DATE = l_last_update_date,
477: LAST_UPDATE_LOGIN = l_last_update_login

Line 480: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor Site

476: LAST_UPDATE_DATE = l_last_update_date,
477: LAST_UPDATE_LOGIN = l_last_update_login
478: WHERE TAX_VENDOR_ID = p_dup_vendor_id;
479:
480: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor Site
481: --Need a separate update as both Vendor and Vendor Site may not be available
482: --together in all the records
483: UPDATE OKL_EXT_BILLING_INTF_ALL
484: SET TAX_VENDOR_SITE_ID = p_vendor_site_id,

Line 483: UPDATE OKL_EXT_BILLING_INTF_ALL

479:
480: --Update OKL_EXT_BILLING_INTF_ALL for references of Vendor Site
481: --Need a separate update as both Vendor and Vendor Site may not be available
482: --together in all the records
483: UPDATE OKL_EXT_BILLING_INTF_ALL
484: SET TAX_VENDOR_SITE_ID = p_vendor_site_id,
485: LAST_UPDATED_BY = l_last_updated_by,
486: LAST_UPDATE_DATE = l_last_update_date,
487: LAST_UPDATE_LOGIN = l_last_update_login