APPS.OKC_CLM_PKG dependencies on OKC_K_ART_VARIABLES

Line 659: okc_k_art_variables KV,

655: VB.clm_ref3,
656: VB.clm_ref4,
657: VB.clm_ref5
658: FROM okc_k_articles_b KA,
659: okc_k_art_variables KV,
660: okc_bus_variables_b VB,
661: okc_bus_variables_tl VBT
662: WHERE VB.variable_code = KV.variable_code
663: and VB.variable_code = VBT.variable_code

Line 824: SELECT kvar.variable_value_id FROM okc_k_art_variables kvar,okc_k_articles_b kart

820: l_api_version CONSTANT NUMBER := 1.0;
821:
822: CURSOR udv_value_csr(p_doc_id number, p_article_id number, p_article_version_id NUMBER)
823: IS
824: SELECT kvar.variable_value_id FROM okc_k_art_variables kvar,okc_k_articles_b kart
825: WHERE kart.id = kvar.cat_id
826: AND kart.document_id = p_doc_id
827: AND kvar.variable_value_id IN
828: (SELECT avs.variable_value_id FROM okc_art_var_sections avs