APPS.IBE_DSP_SECTION_GRP dependencies on IBE_DSP_SECTION_ITEMS

Line 1982: SELECT section_item_id FROM ibe_dsp_section_items

1978: SELECT mini_site_section_section_id FROM ibe_dsp_msite_sct_sects
1979: WHERE child_section_id = l_c_child_section_id;
1980:
1981: CURSOR c2(l_c_section_id IN NUMBER) IS
1982: SELECT section_item_id FROM ibe_dsp_section_items
1983: WHERE section_id = l_c_section_id;
1984:
1985: CURSOR c3(l_c_section_id IN NUMBER) IS
1986: SELECT msite_id FROM ibe_msites_b

Line 2095: -- delete for ibe_dsp_section_items table

2091: END IF;
2092:
2093: END LOOP;
2094:
2095: -- delete for ibe_dsp_section_items table
2096: FOR r2 in c2(l_section_id) LOOP
2097:
2098: IBE_DSP_SECTION_ITEM_PVT.Delete_Section_Item
2099: (