APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SECTIONS_B

Line 873: FROM okc_sections_b

869: WHERE id = p_scc_id;
870:
871: CURSOR c_scn(p_scn_id IN NUMBER) IS
872: SELECT id,level
873: FROM okc_sections_b
874: CONNECT BY PRIOR scn_id = id
875: START WITH id = p_scn_id;
876:
877: PROCEDURE copy_section(

Line 5955: from okc_sections_b

5951:
5952: -- Cursor to get all the top sections
5953: CURSOR get_main_sections(p_chr_id IN NUMBER) IS
5954: select id
5955: from okc_sections_b
5956: where chr_id = p_chr_id
5957: and scn_id IS NULL;
5958: -- Cursor to get all the sub sections in order
5959: CURSOR get_all_sections(p_id IN NUMBER) IS

Line 5961: from okc_sections_b

5957: and scn_id IS NULL;
5958: -- Cursor to get all the sub sections in order
5959: CURSOR get_all_sections(p_id IN NUMBER) IS
5960: select id, level
5961: from okc_sections_b
5962: CONNECT BY PRIOR id = scn_id
5963: START WITH id = p_id;
5964: Begin
5965: OPEN get_main_sections(p_chr_id);