APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on JTF_DSP_MSITE_SCT_SECTS

Line 340: IS SELECT mini_site_section_section_id FROM jtf_dsp_msite_sct_sects

336: l_return_status VARCHAR2(1);
337: l_tmp_id NUMBER;
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');