[Home] [Help]
3038: AND av.article_version_id = rev.article_version_id
3039: AND ((kart_var.variable_type='U' and kart_var.variable_value is null
3040: and (kart_var.variable_value is null
3041: and (rev_var.variable_value is not null and rev_var.variable_value <> '_________' )
3042: and exists(select 'x' from okc_bus_variables_tl bustl where bustl.variable_code = rev_var.variable_code)) OR
3043: (kart_var.variable_value is not null and rev_var.variable_value <> kart_var.variable_value))
3044: OR (kart_var.variable_type<>'U' and exists
3045: (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3046: and var_doc.doc_Type = p_document_type))
3050: and nvl(av.insert_by_reference,'N') <> 'Y';
3051:
3052: cursor variables_removed is
3053: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
3054: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
3055: where rev.object_id = kart_var.cat_id
3056: and rev.document_type = p_document_type and rev.document_id = p_document_id
3057: and rev.article_version_id = av.article_version_id
3058: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var