APPS.JTF_DSP_SECTION_GRP dependencies on JTF_DSP_SECTION_ITEMS

Line 1874: SELECT section_item_id FROM jtf_dsp_section_items

1870: SELECT mini_site_section_section_id FROM jtf_dsp_msite_sct_sects
1871: WHERE child_section_id = l_c_child_section_id;
1872:
1873: CURSOR c2(l_c_section_id IN NUMBER) IS
1874: SELECT section_item_id FROM jtf_dsp_section_items
1875: WHERE section_id = l_c_section_id;
1876:
1877: CURSOR c3(l_c_section_id IN NUMBER) IS
1878: SELECT msite_id FROM jtf_msites_b

Line 1981: -- delete for jtf_dsp_section_items table

1977: END IF;
1978:
1979: END LOOP;
1980:
1981: -- delete for jtf_dsp_section_items table
1982: FOR r2 in c2(l_section_id) LOOP
1983:
1984: JTF_DSP_SECTION_ITEM_PVT.Delete_Section_Item
1985: (