APPS.IBE_M_IBC_INT_PVT dependencies on IBE_MSITES_VL

Line 108: FROM ibe_dsp_lgl_phys_map a, ibe_msites_vl b

104: RETURN VARCHAR2
105: IS
106: CURSOR c_get_store(c_item_key VARCHAR2) IS
107: SELECT decode(b.msite_id, 1, 'All', b.msite_name)
108: FROM ibe_dsp_lgl_phys_map a, ibe_msites_vl b
109: WHERE a.msite_id = b.msite_id and b.site_type = 'I'
110: AND a.content_item_key = c_item_key
111: AND a.attachment_id = -1;
112: -- Need to reconsider the length of the l_stores

Line 113: -- as the length of the store name in ibe_msites_vl

109: WHERE a.msite_id = b.msite_id and b.site_type = 'I'
110: AND a.content_item_key = c_item_key
111: AND a.attachment_id = -1;
112: -- Need to reconsider the length of the l_stores
113: -- as the length of the store name in ibe_msites_vl
114: -- is 4000. but the pl/sql package is only allow
115: -- 240 for now.
116: l_stores VARCHAR2(4000) := NULL;
117: l_store VARCHAR2(4000) := NULL;