DBA Data[Home] [Help]

APPS.OKL_CAF_PVT dependencies on OKL_STRM_TYPE_V

Line 572: FROM Okl_strm_type_V

568: l_dummy_var VARCHAR2(1) := '?' ;
569:
570: CURSOR okl_cafv_styv_fk_csr (p_id IN NUMBER) IS
571: SELECT 'x'
572: FROM Okl_strm_type_V
573: WHERE Okl_strm_type_V.id = p_id;
574: BEGIN
575: -- SECHAWLA sty_id can be null
576: IF (p_cafv_rec.sty_id <> OKL_API.G_MISS_NUM AND p_cafv_rec.sty_id IS NOT NULL)

Line 573: WHERE Okl_strm_type_V.id = p_id;

569:
570: CURSOR okl_cafv_styv_fk_csr (p_id IN NUMBER) IS
571: SELECT 'x'
572: FROM Okl_strm_type_V
573: WHERE Okl_strm_type_V.id = p_id;
574: BEGIN
575: -- SECHAWLA sty_id can be null
576: IF (p_cafv_rec.sty_id <> OKL_API.G_MISS_NUM AND p_cafv_rec.sty_id IS NOT NULL)
577: THEN

Line 592: 'OKL_STRM_TYPE_V');

588: 'sty_id',
589: g_child_table_token ,
590: 'OKL_CASH_FLOWS_V',
591: g_parent_table_token ,
592: 'OKL_STRM_TYPE_V');
593: l_return_status := OKC_API.G_RET_STS_ERROR;
594:
595: END IF;
596: END IF;