92: Cursor l_catv_csr Is
93: SELECT 'E'
94: FROM okc_k_articles_b
95: WHERE SAV_SAE_ID in (
96: SELECT SAE_ID from OKC_STD_ART_INCMPTS_V
97: WHERE SAE_ID_FOR = p_sae_id
98: UNION
99: SELECT SAE_ID_FOR from OKC_STD_ART_INCMPTS_V
100: WHERE SAE_ID = p_sae_id
95: WHERE SAV_SAE_ID in (
96: SELECT SAE_ID from OKC_STD_ART_INCMPTS_V
97: WHERE SAE_ID_FOR = p_sae_id
98: UNION
99: SELECT SAE_ID_FOR from OKC_STD_ART_INCMPTS_V
100: WHERE SAE_ID = p_sae_id
101: )
102: AND DNZ_CHR_ID = p_chr_id
103: AND CHR_ID = p_chr_id