APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_DSP_SECTIONS_VL

Line 1839: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

1835: WHERE access_name = l_c_access_name;
1836:
1837: CURSOR c_get_child_sections( l_section_id in NUMBER ,l_master_mini_site_id in NUMBER) IS
1838: SELECT S.section_id
1839: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
1840: WHERE S.section_id = MSS.child_section_id
1841: AND MSS.mini_site_id = l_master_mini_site_id
1842: AND S.section_id IN
1843: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects

Line 4571: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

4567: S.attribute_category, S.attribute1, S.attribute2, S.attribute3,
4568: S.attribute4, S.attribute5, S.attribute6, S.attribute7, S.attribute8,
4569: S.attribute9, S.attribute10, S.attribute11, S.attribute12, S.attribute13,
4570: S.attribute14, S.attribute15, MSS.sort_order
4571: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
4572: WHERE S.section_id = l_c_section_id
4573: AND MSS.child_section_id = S.section_id
4574: AND MSS.mini_site_id = l_c_master_mini_site_id;
4575:

Line 4589: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS

4585: S.attribute_category, S.attribute1, S.attribute2, S.attribute3,
4586: S.attribute4, S.attribute5, S.attribute6, S.attribute7, S.attribute8,
4587: S.attribute9, S.attribute10, S.attribute11, S.attribute12, S.attribute13,
4588: S.attribute14, S.attribute15, MSS.sort_order, MSS.parent_section_id
4589: FROM ibe_dsp_sections_vl S, ibe_dsp_msite_sct_sects MSS
4590: WHERE S.section_id = MSS.child_section_id
4591: AND MSS.mini_site_id = l_c_master_mini_site_id
4592: AND S.section_id IN
4593: (SELECT child_section_id FROM ibe_dsp_msite_sct_sects