APPS.OKC_K_ARTICLES_GRP dependencies on OKC_BUS_VARIABLES_B

Line 103: OKC_BUS_VARIABLES_B BUSVAR

99:
100: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS
101: SELECT VAR.VARIABLE_CODE, BUSVAR.VARIABLE_TYPE, BUSVAR.EXTERNAL_YN, BUSVAR.VALUE_SET_ID
102: FROM OKC_ARTICLE_VARIABLES VAR,
103: OKC_BUS_VARIABLES_B BUSVAR
104: WHERE VAR.ARTICLE_VERSION_ID = b_article_version_id
105: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE;
106:
107: CURSOR l_get_deleted_rec_csr IS

Line 701: OKC_BUS_VARIABLES_B BUSVAR

697: NULL VARIABLE_VALUE,
698: NULL VARIABLE_VALUE_ID
699: FROM OKC_ARTICLE_VARIABLES VAR,
700: OKC_K_ARTICLES_B KART,
701: OKC_BUS_VARIABLES_B BUSVAR
702: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
703: AND KART.ID = P_ID
704: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE AND NOT EXISTS
705: ( SELECT 'X' FROM OKC_K_ART_VARIABLES

Line 720: OKC_BUS_VARIABLES_B BUSVAR,

716: ARTVAR.VARIABLE_VALUE_ID,
717: ARTVAR.OBJECT_VERSION_NUMBER
718: FROM OKC_ARTICLE_VARIABLES VAR,
719: OKC_K_ARTICLES_B KART,
720: OKC_BUS_VARIABLES_B BUSVAR,
721: OKC_K_ART_VARIABLES ARTVAR
722: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
723: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE
724: AND ARTVAR.CAT_ID = KART.ID