APPS.OKL_VENDORMERGE_GRP dependencies on OKL_K_HEADERS

Line 391: FROM OKL_K_HEADERS KHR

387: LAST_UPDATE_LOGIN = l_last_update_login
388: WHERE OBJECT1_ID1 = TO_CHAR(p_dup_vendor_id)
389: AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'
390: AND EXISTS (SELECT ID
391: FROM OKL_K_HEADERS KHR
392: WHERE KHR.ID = RUL.DNZ_CHR_ID);
393:
394: --Update OKC_RULES_B for reference of Vendor Site in object2_id1, which will
395: --be identified based on value for JTOT_OBJECT2_CODE

Line 404: FROM OKL_K_HEADERS KHR

400: LAST_UPDATE_LOGIN = l_last_update_login
401: WHERE OBJECT2_ID1 = TO_CHAR(p_dup_vendor_site_id)
402: AND JTOT_OBJECT2_CODE IN ('OKX_PAYTO', 'OKX_VENDSITE')
403: AND EXISTS (SELECT ID
404: FROM OKL_K_HEADERS KHR
405: WHERE KHR.ID = RUL.DNZ_CHR_ID);
406:
407: --Update OKC_RULES_B for reference of Vendor Site in object3_id1, which will
408: --be identified based on value for JTOT_OBJECT3_CODE

Line 417: FROM OKL_K_HEADERS KHR

413: LAST_UPDATE_LOGIN = l_last_update_login
414: WHERE OBJECT3_ID1 = TO_CHAR(p_dup_vendor_site_id)
415: AND JTOT_OBJECT3_CODE IN ('OKX_PAYTO', 'OKX_VENDSITE')
416: AND EXISTS (SELECT ID
417: FROM OKL_K_HEADERS KHR
418: WHERE KHR.ID = RUL.DNZ_CHR_ID);
419:
420: --Update OKL_SUBSIDIES_ALL_B for reference of Vendor
421: UPDATE OKL_SUBSIDIES_ALL_B

Line 756: FROM OKL_K_HEADERS KHR

752: LAST_UPDATE_LOGIN = l_last_update_login
753: WHERE OBJECT1_ID1 = TO_CHAR(p_dup_vendor_id)
754: AND JTOT_OBJECT1_CODE = 'OKX_VENDOR'
755: AND EXISTS (SELECT ID
756: FROM OKL_K_HEADERS KHR
757: WHERE KHR.ID = CPR.DNZ_CHR_ID);
758:
759: OKL_API.END_ACTIVITY(
760: x_msg_count => p_msg_count