APPS.IBE_DSP_SECTION_GRP dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 1978: SELECT mini_site_section_section_id FROM ibe_dsp_msite_sct_sects

1974: l_section_id NUMBER;
1975: l_mini_site_id NUMBER;
1976:
1977: CURSOR c1(l_c_child_section_id IN NUMBER) IS
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

Line 2069: -- delete from ibe_dsp_msite_sct_sects table

2065: FND_MSG_PUB.Add;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: -- delete from ibe_dsp_msite_sct_sects table
2070: FOR r1 in c1(l_section_id) LOOP
2071:
2072: IBE_DSP_MSITE_SCT_SECT_PVT.Delete_MSite_Section_Section
2073: (