APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on JTF_MSITES_B

Line 342: AND EXISTS (SELECT msite_id FROM jtf_msites_b

338:
339: CURSOR c1(l_c_section_id IN NUMBER)
340: IS SELECT mini_site_section_section_id FROM jtf_dsp_msite_sct_sects
341: WHERE parent_section_id = l_c_section_id
342: AND EXISTS (SELECT msite_id FROM jtf_msites_b
343: WHERE msite_id = mini_site_id
344: AND master_msite_flag = 'Y');
345:
346: BEGIN