APPS.OKL_SRL_PVT dependencies on OKL_SIF_RETS_V

Line 498: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS

494: l_dummy VARCHAR2(1) := '?';
495: l_row_not_found BOOLEAN := FALSE;
496:
497: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
498: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
499: SELECT '1'
500: FROM OKL_Sif_rets_V
501: WHERE OKL_Sif_rets_V.id = p_id;
502: -- smahapat change end

Line 500: FROM OKL_Sif_rets_V

496:
497: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
498: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
499: SELECT '1'
500: FROM OKL_Sif_rets_V
501: WHERE OKL_Sif_rets_V.id = p_id;
502: -- smahapat change end
503:
504: BEGIN

Line 501: WHERE OKL_Sif_rets_V.id = p_id;

497: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
498: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
499: SELECT '1'
500: FROM OKL_Sif_rets_V
501: WHERE OKL_Sif_rets_V.id = p_id;
502: -- smahapat change end
503:
504: BEGIN
505: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 709: FROM okl_sif_rets_v

705: ) RETURN VARCHAR2 IS
706: item_not_found_error EXCEPTION;
707: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
708: SELECT 'x'
709: FROM okl_sif_rets_v
710: WHERE okl_sif_rets_v.id = p_id;
711: l_okl_sifv_sirv_fk okl_sifv_sirv_fk_csr%ROWTYPE;
712:
713: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 710: WHERE okl_sif_rets_v.id = p_id;

706: item_not_found_error EXCEPTION;
707: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
708: SELECT 'x'
709: FROM okl_sif_rets_v
710: WHERE okl_sif_rets_v.id = p_id;
711: l_okl_sifv_sirv_fk okl_sifv_sirv_fk_csr%ROWTYPE;
712:
713: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
714: l_row_notfound BOOLEAN := TRUE;