APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 1095: (SELECT mini_site_id FROM ibe_dsp_msite_sct_items

1091: --
1092: OPEN x_incl_mini_site_csr FOR SELECT msite_id, msite_name, msite_description
1093: FROM ibe_msites_vl
1094: WHERE EXISTS
1095: (SELECT mini_site_id FROM ibe_dsp_msite_sct_items
1096: WHERE mini_site_id = msite_id
1097: AND section_item_id IN
1098: (SELECT section_item_id FROM ibe_dsp_section_items
1099: WHERE inventory_item_id = p_inventory_item_id