APPS.OKC_SCC_PVT dependencies on OKC_SECTIONS_B

Line 24: from OKC_SECTIONS_B

20:
21: l_dummy_var VARCHAR2(1) := '?';
22: Cursor l_scnv_csr Is
23: select 'x'
24: from OKC_SECTIONS_B
25: where id = p_sccv_rec.scn_id;
26:
27: Begin
28:

Line 909: FROM okc_sections_b

905: SELECT count(*)
906: FROM okc_section_contents_v
907: WHERE cat_id = p_sccv_rec.CAT_ID
908: AND scn_id IN (SELECT id
909: FROM okc_sections_b
910: WHERE chr_id = (SELECT chr_id
911: FROM okc_sections_b
912: WHERE id = p_sccv_rec.SCN_ID))
913: AND id <> p_sccv_rec.id;

Line 911: FROM okc_sections_b

907: WHERE cat_id = p_sccv_rec.CAT_ID
908: AND scn_id IN (SELECT id
909: FROM okc_sections_b
910: WHERE chr_id = (SELECT chr_id
911: FROM okc_sections_b
912: WHERE id = p_sccv_rec.SCN_ID))
913: AND id <> p_sccv_rec.id;
914: BEGIN
915:

Line 3171: FROM okc_sections_b

3167: attribute14,
3168: attribute15
3169: FROM okc_section_contents
3170: WHERE scn_id in (SELECT id
3171: FROM okc_sections_b
3172: WHERE CHR_ID=p_chr_id);
3173:
3174: IF (l_debug = 'Y') THEN
3175: okc_debug.log('11000: Leaving create_version', 2);

Line 3295: FROM okc_sections_bh

3291: attribute14,
3292: attribute15
3293: FROM okc_section_contents_h
3294: WHERE scn_id in (SELECT id
3295: FROM okc_sections_bh
3296: WHERE chr_id = p_chr_id)
3297: AND major_version = p_major_version;
3298:
3299: IF (l_debug = 'Y') THEN