APPS.OKL_SXP_PVT dependencies on OKL_STREAM_INTERFACES_V

Line 426: CURSOR okl_sifv_pk_csr (p_id IN OKL_STREAM_INTERFACES_V.id%TYPE) IS

422: l_dummy VARCHAR2(1) := '?';
423: l_row_not_found BOOLEAN := FALSE;
424:
425: -- Cursor For OKL_SIL_SIF_FK;
426: CURSOR okl_sifv_pk_csr (p_id IN OKL_STREAM_INTERFACES_V.id%TYPE) IS
427: SELECT '1'
428: FROM OKL_STREAM_INTERFACES_V
429: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
430:

Line 428: FROM OKL_STREAM_INTERFACES_V

424:
425: -- Cursor For OKL_SIL_SIF_FK;
426: CURSOR okl_sifv_pk_csr (p_id IN OKL_STREAM_INTERFACES_V.id%TYPE) IS
427: SELECT '1'
428: FROM OKL_STREAM_INTERFACES_V
429: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
430:
431: BEGIN
432:

Line 429: WHERE OKL_STREAM_INTERFACES_V.id = p_id;

425: -- Cursor For OKL_SIL_SIF_FK;
426: CURSOR okl_sifv_pk_csr (p_id IN OKL_STREAM_INTERFACES_V.id%TYPE) IS
427: SELECT '1'
428: FROM OKL_STREAM_INTERFACES_V
429: WHERE OKL_STREAM_INTERFACES_V.id = p_id;
430:
431: BEGIN
432:
433: -- initialize return status