DBA Data[Home] [Help]

APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_STD_ART_INCMPTS_V

Line 96: SELECT SAE_ID from OKC_STD_ART_INCMPTS_V

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

Line 99: SELECT SAE_ID_FOR from OKC_STD_ART_INCMPTS_V

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