APPS.JTF_DSP_SECTION_GRP dependencies on JTF_DSP_MSITE_SCT_SECTS

Line 1870: SELECT mini_site_section_section_id FROM jtf_dsp_msite_sct_sects

1866: l_section_id NUMBER;
1867: l_mini_site_id NUMBER;
1868:
1869: CURSOR c1(l_c_child_section_id IN NUMBER) IS
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

Line 1955: -- delete from jtf_dsp_msite_sct_sects table

1951: FND_MSG_PUB.Add;
1952: RAISE FND_API.G_EXC_ERROR;
1953: END IF;
1954:
1955: -- delete from jtf_dsp_msite_sct_sects table
1956: FOR r1 in c1(l_section_id) LOOP
1957:
1958: JTF_DSP_MSITE_SCT_SECT_PVT.Delete_MSite_Section_Section
1959: (