APPS.OKL_SRL_PVT dependencies on OKL_SIF_RETS_V

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

479: l_dummy VARCHAR2(1) := '?';
480: l_row_not_found BOOLEAN := FALSE;
481:
482: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
483: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
484: SELECT '1'
485: FROM OKL_Sif_rets_V
486: WHERE OKL_Sif_rets_V.id = p_id;
487: -- smahapat change end

Line 485: FROM OKL_Sif_rets_V

481:
482: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
483: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
484: SELECT '1'
485: FROM OKL_Sif_rets_V
486: WHERE OKL_Sif_rets_V.id = p_id;
487: -- smahapat change end
488:
489: BEGIN

Line 486: WHERE OKL_Sif_rets_V.id = p_id;

482: -- Cursor For OKL_SIF_RETS - Foreign Key Constraint
483: CURSOR okl_sir_pk_csr (p_id IN OKL_SIF_RETS_V.id%TYPE) IS
484: SELECT '1'
485: FROM OKL_Sif_rets_V
486: WHERE OKL_Sif_rets_V.id = p_id;
487: -- smahapat change end
488:
489: BEGIN
490: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 694: FROM okl_sif_rets_v

690: ) RETURN VARCHAR2 IS
691: item_not_found_error EXCEPTION;
692: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
693: SELECT 'x'
694: FROM okl_sif_rets_v
695: WHERE okl_sif_rets_v.id = p_id;
696: l_okl_sifv_sirv_fk okl_sifv_sirv_fk_csr%ROWTYPE;
697:
698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 695: WHERE okl_sif_rets_v.id = p_id;

691: item_not_found_error EXCEPTION;
692: CURSOR okl_sifv_sirv_fk_csr (p_id IN NUMBER) IS
693: SELECT 'x'
694: FROM okl_sif_rets_v
695: WHERE okl_sif_rets_v.id = p_id;
696: l_okl_sifv_sirv_fk okl_sifv_sirv_fk_csr%ROWTYPE;
697:
698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
699: l_row_notfound BOOLEAN := TRUE;