APPS.PO_EDA_DATATEMPLATE_PKG dependencies on OKC_K_ART_VARIABLES

Line 2071: FROM okc_k_articles_b kart, okc_k_art_variables var

2067: i NUMBER := 1;
2068: l_doc_class VARCHAR2(30) := '?';
2069: CURSOR var_doc_lst_crs IS
2070: SELECT distinct var.variable_code
2071: FROM okc_k_articles_b kart, okc_k_art_variables var
2072: WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
2073: and var.cat_id=kart.id AND variable_type='S';
2074:
2075: CURSOR var_def_lst_crs IS

Line 3004: SELECT VARIABLE_VALUE,VARIABLE_VALUE_ID FROM okc_k_art_variables WHERE CAT_ID = p_kart_id AND VARIABLE_CODE = p_var_code;

3000:
3001: l_var_seq_num NUMBER :=1;
3002:
3003: CURSOR c_varvalue(p_var_code VARCHAR2) is
3004: SELECT VARIABLE_VALUE,VARIABLE_VALUE_ID FROM okc_k_art_variables WHERE CAT_ID = p_kart_id AND VARIABLE_CODE = p_var_code;
3005:
3006: BEGIN
3007:
3008: SELECT sav_sae_id,article_version_id INTO l_article_id,l_article_ver_id FROM okc_k_articles_b WHERE id = p_kart_id;