eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on IBE_DSP_MSITE_SCT_SECTS

Line 190: FROM ibe_dsp_msite_sct_sects

186: -- Check if a section has subsection or not
187: CURSOR c_check_leaf_section(c_section_id NUMBER,
188: c_master_mini_site_id NUMBER) IS
189: SELECT 1
190: FROM ibe_dsp_msite_sct_sects
191: WHERE mini_site_id = c_master_mini_site_id
192: AND parent_section_id = c_section_id;
193:
194: BEGIN

Line 280: FROM ibe_dsp_msite_sct_sects

276: AND origin_object_id = c_section_id;
277: /*
278: CURSOR c_section_msites(c_section_id NUMBER) IS
279: SELECT DISTINCT mini_site_id
280: FROM ibe_dsp_msite_sct_sects
281: WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
282: AND child_section_id = c_section_id;
283: */
284: -- start_date, end_date

Line 850: FROM ibe_dsp_msite_sct_sects

846:
847: CURSOR c_subsections(c_section_id NUMBER,
848: c_master_mini_site_id NUMBER) IS
849: SELECT child_section_id
850: FROM ibe_dsp_msite_sct_sects
851: WHERE mini_site_id = c_master_mini_site_id
852: AND sysdate BETWEEN start_date_active AND NVL(end_date_active,sysdate)
853: START WITH child_section_id = c_section_id
854: AND mini_site_id = c_master_mini_site_id