DBA Data[Home] [Help]

APPS.OKL_SIF_PVT dependencies on OKL_K_HEADERS_V

Line 997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS

993: l_dummy VARCHAR2(1) := '?';
994: l_row_not_found BOOLEAN := FALSE;
995:
996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:

Line 999: FROM OKL_K_HEADERS_V

995:
996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:
1002: BEGIN
1003: -- initialize return status

Line 1000: WHERE OKL_K_HEADERS_V.id = p_id;

996: -- Cursor For OKL_K_HEADERS - Foreign Key Constraint
997: CURSOR okl_Khr_pk_csr (p_id IN OKL_K_HEADERS_V.id%TYPE) IS
998: SELECT '1'
999: FROM OKL_K_HEADERS_V
1000: WHERE OKL_K_HEADERS_V.id = p_id;
1001:
1002: BEGIN
1003: -- initialize return status
1004: x_return_status := Okc_Api.G_RET_STS_SUCCESS;