APPS.AMS_MINISITE_DENORM_PVT dependencies on IBE_MSITES_B

Line 23: select MSITE_ID, MSITE_ROOT_SECTION_ID, START_DATE_ACTIVE from ibe_msites_b

19: l_oracle_schema_AppInfo varchar2(300) ;
20: l_application_short_name varchar2(300) ;
21:
22: CURSOR compCur IS
23: select MSITE_ID, MSITE_ROOT_SECTION_ID, START_DATE_ACTIVE from ibe_msites_b
24: where msite_id <> 1;
25: -- where END_DATE_ACTIVE > sysdate ;
26:
27: cursor allTopLevelSections(l_minisite_id in number, l_msite_root_section_id in number) IS

Line 35: -- from ibe_msites_b cc

31: AND mss.mini_site_id = l_minisite_id
32: AND s.section_id = mss.child_section_id
33: AND s.section_type_code = 'N'
34: --and not exists (select 1
35: -- from ibe_msites_b cc
36: -- where s.section_id = cc.MSITE_ROOT_SECTION_ID
37: -- )
38: -- AND NVL(mss.start_date_active, SYSDATE) <= SYSDATE
39: -- AND NVL(mss.end_date_active, SYSDATE) >= SYSDATE