DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SECTION_CONTENTS_V

Line 867: FROM okc_section_contents_v

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

Line 1541: FROM okc_section_contents_v

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

Line 8808: FROM OKC_SECTION_CONTENTS_V

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