APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_DSP_MSITE_SCT_ITEMS

Line 205: || '(SELECT section_item_id FROM jtf_dsp_msite_sct_items '

201: || 'OR (section_id IN '
202: || '(SELECT child_section_id FROM jtf_dsp_msite_sct_sects '
203: || 'WHERE mini_site_id = :msite_id) '
204: || 'AND section_item_id NOT IN '
205: || '(SELECT section_item_id FROM jtf_dsp_msite_sct_items '
206: || 'WHERE mini_site_id = :msite_id))) '
207: USING x_master_msite_id, l_msite_id, l_root_section_id,
208: x_master_msite_id, x_master_msite_id, x_master_msite_id,
209: l_msite_id, l_msite_id;

Line 364: -- (SELECT section_item_id FROM jtf_dsp_msite_sct_items

360: -- OR (section_id IN
361: -- (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
362: -- WHERE mini_site_id = l_c_msite_id)
363: -- AND section_item_id NOT IN
364: -- (SELECT section_item_id FROM jtf_dsp_msite_sct_items
365: -- WHERE mini_site_id = l_c_msite_id)));
366:
367: CURSOR c2(l_c_master_msite_id IN NUMBER, l_c_msite_id IN NUMBER)
368: IS SELECT inventory_item_id

Line 389: (SELECT section_item_id FROM jtf_dsp_msite_sct_items

385: OR (section_id IN
386: (SELECT child_section_id FROM jtf_dsp_msite_sct_sects
387: WHERE mini_site_id = l_c_msite_id)
388: AND section_item_id NOT IN
389: (SELECT section_item_id FROM jtf_dsp_msite_sct_items
390: WHERE mini_site_id = l_c_msite_id)));
391:
392: CURSOR c3
393: IS SELECT msite_id FROM jtf_msites_b