DBA Data[Home] [Help]

APPS.OKC_SAI_PVT dependencies on OKC_STD_ARTICLES_B

Line 297: FROM okc_std_articles_b sae

293: procedure validate_sae_id(p_saiv_rec IN saiv_rec_type,
294: x_return_status OUT NOCOPY VARCHAR2) is
295: CURSOR l_sae_id_csr IS
296: SELECT '1'
297: FROM okc_std_articles_b sae
298: WHERE sae.id = p_saiv_rec.sae_id;
299: l_dummy_var VARCHAR2(1):='0';
300:
301: BEGIN

Line 366: FROM okc_std_articles_b sae

362: procedure validate_sae_id_for(p_saiv_rec IN saiv_rec_type,
363: x_return_status OUT NOCOPY VARCHAR2) is
364: CURSOR l_sae_id_csr IS
365: SELECT '1'
366: FROM okc_std_articles_b sae
367: WHERE sae.id = p_saiv_rec.sae_id_for;
368: l_dummy_var VARCHAR2(1):='0';
369:
370: BEGIN