APPS.OKL_SXP_PVT dependencies on OKL_SIF_PRICE_PARMS_V

Line 500: CURSOR okl_sppv_pk_csr (p_id IN OKL_SIF_PRICE_PARMS_V.id%TYPE) IS

496: l_dummy VARCHAR2(1) := '?';
497: l_row_not_found BOOLEAN := FALSE;
498:
499: -- Cursor For OKL_SPP_FK;
500: CURSOR okl_sppv_pk_csr (p_id IN OKL_SIF_PRICE_PARMS_V.id%TYPE) IS
501: SELECT '1'
502: FROM OKL_SIF_PRICE_PARMS_V
503: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;
504:

Line 502: FROM OKL_SIF_PRICE_PARMS_V

498:
499: -- Cursor For OKL_SPP_FK;
500: CURSOR okl_sppv_pk_csr (p_id IN OKL_SIF_PRICE_PARMS_V.id%TYPE) IS
501: SELECT '1'
502: FROM OKL_SIF_PRICE_PARMS_V
503: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;
504:
505: BEGIN
506:

Line 503: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;

499: -- Cursor For OKL_SPP_FK;
500: CURSOR okl_sppv_pk_csr (p_id IN OKL_SIF_PRICE_PARMS_V.id%TYPE) IS
501: SELECT '1'
502: FROM OKL_SIF_PRICE_PARMS_V
503: WHERE OKL_SIF_PRICE_PARMS_V.id = p_id;
504:
505: BEGIN
506:
507: -- initialize return status