APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SECTIONS_B

Line 872: FROM okc_sections_b

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

Line 5954: from okc_sections_b

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

Line 5960: from okc_sections_b

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