APPS.OKL_CSP_PVT dependencies on OKL_K_HEADERS_V

Line 13: -- Description : FK validation with OKL_K_HEADERS_V

9: --------------------------------------------------------------------------------
10: -- Start of Commnets
11: -- Badrinath Kuchibholta
12: -- Procedure Name : Validate_khr_id
13: -- Description : FK validation with OKL_K_HEADERS_V
14: -- Business Rules :
15: -- Parameters : OUT Return Status, IN Rec Info
16: -- Version : 1.0
17: -- End of Commnets

Line 23: CURSOR c_khr_id_validate(p_khr_id OKL_K_HEADERS_V.ID%TYPE) is

19: PROCEDURE validate_khr_id(x_return_status OUT NOCOPY VARCHAR2,
20: p_cspv_rec IN cspv_rec_type) IS
21:
22: ln_dummy number := 0;
23: CURSOR c_khr_id_validate(p_khr_id OKL_K_HEADERS_V.ID%TYPE) is
24: SELECT 1
25: FROM DUAL
26: WHERE EXISTS (SELECT '1'
27: FROM OKL_K_HEADERS khrv