DBA Data[Home] [Help]

APPS.OKL_TAL_PVT dependencies on OKC_K_HEADERS_B

Line 579: FROM OKC_K_HEADERS_B chrv,

575: p_kle_id OKL_TXL_ASSETS_B.KLE_ID%TYPE) is
576: SELECT 1
577: FROM DUAL
578: WHERE EXISTS (SELECT chrv.authoring_org_id
579: FROM OKC_K_HEADERS_B chrv,
580: OKC_K_LINES_B cle,
581: OKL_K_LINES_V kle
582: WHERE kle.id = p_kle_id
583: AND kle.id = cle.id

Line 968: FROM OKC_K_HEADERS_B chrv

964: CURSOR c_dnz_khr_id_validate(p_dnz_khr_id OKL_TXL_ASSETS_V.DNZ_KHR_ID%TYPE) is
965: SELECT 1
966: FROM DUAL
967: WHERE EXISTS (SELECT '1'
968: FROM OKC_K_HEADERS_B chrv
969: WHERE chrv.id = p_dnz_khr_id);
970: BEGIN
971: -- initialize return status
972: x_return_status := OKC_API.G_RET_STS_SUCCESS;