APPS.IBE_SEARCHUPDATE_PVT dependencies on IBE_DSP_SECTIONS_B

Line 100: TYPE t_section_id IS TABLE of ibe_dsp_sections_b.section_id%TYPE

96: TYPE t_category_set_id IS TABLE OF ibe_ct_imedia_search.CATEGORY_SET_ID%TYPE
97: INDEX BY BINARY_INTEGER;
98: TYPE t_web_status IS TABLE OF ibe_ct_imedia_search.WEB_STATUS%TYPE
99: INDEX BY BINARY_INTEGER;
100: TYPE t_section_id IS TABLE of ibe_dsp_sections_b.section_id%TYPE
101: INDEX BY BINARY_INTEGER;
102:
103:
104: l_use_category_search VARCHAR(50);

Line 137: FROM IBE_DSP_MSITE_SCT_SECTS mss, IBE_DSP_SECTIONS_B s

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
138: WHERE mss.parent_section_id = l_msite_root_section_id
139: AND mss.mini_site_id = l_minisite_id
140: AND s.section_id = mss.child_section_id
141: AND s.section_type_code = 'N'

Line 264: ibe_dsp_sections_b s

260: FND_GLOBAL.user_id,
261: SYSDATE,
262: FND_GLOBAL.conc_login_id
263: from ibe_dsp_section_items f ,
264: ibe_dsp_sections_b s
265: where (f.end_date_active > sysdate or f.end_date_active is null)
266: and f.start_date_active < sysdate
267: and f.section_id = s.section_id
268: and s.status_code = 'PUBLISHED' and f.section_id in

Line 287: ibe_dsp_sections_b s

283: SYSDATE,
284: FND_GLOBAL.conc_login_id
285: from ibe_dsp_section_items f ,
286: mtl_system_items_b g,
287: ibe_dsp_sections_b s
288: where f.inventory_item_id = g.inventory_item_id
289: and (f.end_date_active > sysdate or f.end_date_active is null)
290: and f.start_date_active < sysdate
291: and f.section_id = s.section_id