APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on IBE_MSITES_B

Line 54: FROM ibe_msites_b JMB

50:
51: -- Get the master minisite id
52: SELECT JMB.msite_id
53: INTO l_master_msite_id
54: FROM ibe_msites_b JMB
55: WHERE JMB.master_msite_flag = 'Y' and
56: JMB.site_type = 'I';
57:
58: -- Open a cursor that retrieves the sections path from the root section

Line 885: -- ibe_msites_b table for which the msite_root_section is null or the master root section id

881: ELSE
882: --
883: -- Parent section ID is null (or p_section_id is root section id),
884: -- therefor list of candidate sites will be all the mini-sites in
885: -- ibe_msites_b table for which the msite_root_section is null or the master root section id
886: --
887: OPEN x_cndt_mini_site_csr FOR SELECT msite_id, msite_name,
888: msite_description
889: FROM ibe_msites_vl