DBA Data[Home] [Help]

APPS.OKC_ART_BLK_PVT dependencies on OKC_BUS_VARIABLES_TL

Line 530: FROM OKC_BUS_VARIABLES_TL BVT,

526: -- check for disabled variables
527: CURSOR l_disabled_var_csr (cp_id IN NUMBER) IS
528: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title),
529: BVT.variable_name
530: FROM OKC_BUS_VARIABLES_TL BVT,
531: OKC_BUS_VARIABLES_B BVB,
532: OKC_ARTICLE_VARIABLES AAV,
533: OKC_ART_BLK_TEMP TMP
534: WHERE TMP.id = cp_id

Line 547: FROM OKC_BUS_VARIABLES_TL BVT,

543: CURSOR l_invalid_valueset_csr (cp_id IN NUMBER) IS
544: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title),
545: BVT.variable_name,
546: nvl(FVS.flex_value_set_id, -99)
547: FROM OKC_BUS_VARIABLES_TL BVT,
548: FND_FLEX_VALUE_SETS FVS,
549: OKC_BUS_VARIABLES_B BVB,
550: OKC_ARTICLE_VARIABLES AAV,
551: OKC_ART_BLK_TEMP TMP