DBA Data[Home] [Help]

APPS.OKC_ART_BLK_PVT dependencies on OKC_BUS_VARIABLES_B

Line 531: OKC_BUS_VARIABLES_B BVB,

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
535: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses

Line 549: OKC_BUS_VARIABLES_B BVB,

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
552: WHERE TMP.id = cp_id
553: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses