APPS.AMS_MINISITE_DENORM_PVT dependencies on IBE_DSP_SECTIONS_B

Line 29: FROM ibe_dsp_msite_sct_sects mss, ibe_dsp_sections_b s

25: -- where END_DATE_ACTIVE > sysdate ;
26:
27: cursor allTopLevelSections(l_minisite_id in number, l_msite_root_section_id in number) IS
28: SELECT distinct s.section_id
29: FROM ibe_dsp_msite_sct_sects mss, ibe_dsp_sections_b s
30: WHERE mss.parent_section_id = l_msite_root_section_id
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'

Line 70: from ibe_dsp_sections_b s

66: )
67: and NOT EXISTS
68: (
69: select 1
70: from ibe_dsp_sections_b s
71: where s.section_id = cs.child_section_id
72: and s.status_code = 'UNPUBLISHED'
73: )
74: );

Line 96: -- from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s

92: -- )
93: -- MINUS
94: -- (
95: -- select s.section_id
96: -- from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s
97: -- where mss3.child_section_id = s.section_id
98: -- and s.status_code = 'UNPUBLISHED'
99: -- and mss3.mini_site_id = p_msite_id
100: -- )

Line 177: from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s

173: )
174: MINUS
175: (
176: select s.section_id
177: from ibe_DSP_MSITE_SCT_SECTS mss3 , ibe_dsp_sections_b s
178: where mss3.child_section_id = s.section_id
179: and s.status_code = 'UNPUBLISHED'
180: and mss3.mini_site_id = v_CompoundData.MSITE_ID
181: )