DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PVT dependencies on IBE_MSITES_VL

Line 880: FROM ibe_msites_vl

876: WHERE master_msite_flag = 'Y';
877:
878: CURSOR c5(l_c_master_mini_site_id IN NUMBER)
879: IS SELECT msite_id
880: FROM ibe_msites_vl
881: WHERE msite_id <> l_c_master_mini_site_id;
882:
883: CURSOR c6(l_c_master_mini_site_id IN NUMBER,
884: l_c_section_id IN NUMBER,

Line 887: FROM ibe_msites_vl

883: CURSOR c6(l_c_master_mini_site_id IN NUMBER,
884: l_c_section_id IN NUMBER,
885: l_c_parent_section_id IN NUMBER)
886: IS SELECT msite_id
887: FROM ibe_msites_vl
888: WHERE msite_id <> l_c_master_mini_site_id AND
889: (msite_root_section_id = l_c_section_id OR
890: EXISTS (SELECT mini_site_id FROM ibe_dsp_msite_sct_sects
891: WHERE mini_site_id = msite_id