APPS.OKL_TAL_PVT dependencies on OKL_K_LINES_V

Line 425: -- Description : FK validation with OKL_K_LINES_V

421: ----------------------------------6-----------------------------------------------
422: -- Start of Commnets
423: -- Badrinath Kuchibholta
424: -- Procedure Name : Validate_kle_id
425: -- Description : FK validation with OKL_K_LINES_V
426: -- Business Rules :
427: -- Parameters : OUT Return Status, IN Rec Info
428: -- Version : 1.0
429: -- End of Commnets

Line 439: FROM OKL_K_LINES_V

435: CURSOR c_kle_id_validate(p_id number) is
436: SELECT 1
437: FROM DUAL
438: WHERE EXISTS (SELECT id
439: FROM OKL_K_LINES_V
440: WHERE id = p_id);
441: BEGIN
442: -- initialize return status
443: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 581: OKL_K_LINES_V kle

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
584: AND cle.dnz_chr_id = chrv.id
585: AND chrv.authoring_org_id = p_org_id);