APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_BUS_VARIABLES_B

Line 357: FROM OKC_BUS_VARIABLES_B

353: WHERE FLEX_VALUE_SET_ID = p_attribute_value_set_id;
354:
355: CURSOR l_variable_code_csr is
356: SELECT '!'
357: FROM OKC_BUS_VARIABLES_B
358: WHERE VARIABLE_CODE = p_VARIABLE_CODE;
359: BEGIN
360:
361: /*IF (l_debug = 'Y') THEN

Line 2012: , OKC_BUS_VARIABLES_B BUS_VAR

2008: CURSOR cat_mrv_csr
2009: IS
2010: SELECT kart.ID
2011: FROM OKC_K_ARTICLES_B KART
2012: , OKC_BUS_VARIABLES_B BUS_VAR
2013: , OKC_K_ART_VARIABLES KVAR
2014: WHERE kart.SCN_ID=p_scn_id
2015: AND KVAR.cat_id=kart.id
2016: AND KVAR.variable_code=BUS_VAR.variable_code

Line 2152: , OKC_BUS_VARIABLES_B BUS_VAR

2148: CURSOR doc_mrv_csr
2149: IS
2150: SELECT kart.ID
2151: FROM OKC_K_ARTICLES_B KART
2152: , OKC_BUS_VARIABLES_B BUS_VAR
2153: , OKC_K_ART_VARIABLES KVAR
2154: WHERE kart.document_type=p_doc_type
2155: AND kart.document_id = p_doc_id
2156: AND KVAR.cat_id=kart.id

Line 2291: , OKC_BUS_VARIABLES_B BUS_VAR

2287: CURSOR doc_mrv_csr
2288: IS
2289: SELECT kart.ID
2290: FROM OKC_K_ARTICLES_B KART
2291: , OKC_BUS_VARIABLES_B BUS_VAR
2292: , OKC_K_ART_VARIABLES KVAR
2293: WHERE kart.document_type=p_doc_type
2294: AND kart.document_id = p_doc_id
2295: AND KVAR.cat_id=kart.id

Line 2410: , OKC_BUS_VARIABLES_B BUS_VAR

2406: CURSOR doc_ver_mrv_csr
2407: IS
2408: SELECT kart.ID
2409: FROM OKC_K_ARTICLES_BH KART
2410: , OKC_BUS_VARIABLES_B BUS_VAR
2411: , OKC_K_ART_VARIABLES_H KVAR
2412: WHERE kart.document_type=p_doc_type
2413: AND kart.document_id = p_doc_id
2414: AND KVAR.cat_id=kart.id

Line 2524: , OKC_BUS_VARIABLES_B BUS_VAR

2520: CURSOR doc_ver_mrv_csr
2521: IS
2522: SELECT kart.ID
2523: FROM OKC_K_ARTICLES_BH KART
2524: , OKC_BUS_VARIABLES_B BUS_VAR
2525: , OKC_K_ART_VARIABLES_H KVAR
2526: WHERE kart.document_type=p_doc_type
2527: AND kart.document_id = p_doc_id
2528: AND KVAR.cat_id=kart.id

Line 2603: FROM okc_bus_variables_b var

2599: INTO l_mrv_flag
2600: FROM okc_k_art_variables kav
2601: WHERE cat_id = p_cat_id
2602: AND EXISTS (SELECT 1
2603: FROM okc_bus_variables_b var
2604: WHERE kav.variable_code=var.variable_code
2605: AND var.mrv_flag='Y');
2606: ELSE
2607: SELECT Nvl(mrv_flag,'N')

Line 2609: FROM okc_bus_variables_b

2605: AND var.mrv_flag='Y');
2606: ELSE
2607: SELECT Nvl(mrv_flag,'N')
2608: INTO l_mrv_flag
2609: FROM okc_bus_variables_b
2610: WHERE variable_code=p_variable_code;
2611: END IF;
2612: RETURN l_mrv_flag;
2613: EXCEPTION