DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SECTION_CONTENTS_V

Line 868: FROM okc_section_contents_v

864: l_sec sec_tbl_type;
865:
866: CURSOR c_scc IS
867: SELECT scn_id
868: FROM okc_section_contents_v
869: WHERE id = p_scc_id;
870:
871: CURSOR c_scn(p_scn_id IN NUMBER) IS
872: SELECT id,level

Line 1542: FROM okc_section_contents_v

1538: WHERE cat_id = p_id;
1539:
1540: CURSOR c_scc IS
1541: SELECT id
1542: FROM okc_section_contents_v
1543: WHERE cat_id = p_cat_id;
1544:
1545: BEGIN
1546: IF (l_debug = 'Y') THEN

Line 8809: FROM OKC_SECTION_CONTENTS_V

8805: ATTRIBUTE12,
8806: ATTRIBUTE13,
8807: ATTRIBUTE14,
8808: ATTRIBUTE15
8809: FROM OKC_SECTION_CONTENTS_V
8810: WHERE ID = p_scc_id;
8811: BEGIN
8812: OPEN c_sccv_rec;
8813: FETCH c_sccv_rec