APPS.IBE_SEARCHUPDATE_PVT dependencies on IBE_MSITES_B

Line 129: from ibe_msites_b

125: --anita end ---
126:
127: CURSOR compCur IS
128: select MSITE_ID,MSITE_ROOT_SECTION_ID
129: from ibe_msites_b
130: where msite_id <> 1 and site_type = 'I';
131: -- where END_DATE_ACTIVE > sysdate ;
132:
133: -- sytong, bug fix 2550153, remove extra table ibe_msites_b in from clause

Line 133: -- sytong, bug fix 2550153, remove extra table ibe_msites_b in from clause

129: from ibe_msites_b
130: where msite_id <> 1 and site_type = 'I';
131: -- where END_DATE_ACTIVE > sysdate ;
132:
133: -- sytong, bug fix 2550153, remove extra table ibe_msites_b in from clause
134: cursor allTopLevelSections(l_minisite_id in number,
135: l_msite_root_section_id in number) IS
136: SELECT distinct s.section_id
137: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B s

Line 201: FROM ibe_msites_b

197:
198:
199: CURSOR c3 IS
200: SELECT msite_id, msite_root_section_id
201: FROM ibe_msites_b
202: WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate)
203: AND master_msite_flag = 'N' AND site_type = 'I';
204:
205: --added new cursor :ab-------

Line 309: from ibe_msites_b

305: /* Now after loading the data we will remove the catalog
306: exclusions for item to minisite from the table
307: */
308: select msite_id into l_master_msite_id
309: from ibe_msites_b
310: where UPPER(master_msite_flag) = 'Y' and site_type = 'I';
311:
312: l_index := 1;
313: FOR r3 IN c3 LOOP