APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_MSITE_RESPS_B

Line 224: From jtf_msite_resps_b respb ,

220: respb.responsibility_id ,
221: respb.application_id,
222: respt.language,
223: respt.display_name
224: From jtf_msite_resps_b respb ,
225: jtf_msite_resps_tl respt ,
226: jtf_msite_languages lang
227: Where respb.msite_id = l_msite_id
228: And respb.msite_resp_id = respt.msite_resp_id

Line 482: -- Mini-site and responsibility association (from jtf_msite_resps_b, _tl)

478: || 'MM.msite_id = C.msite_id AND '
479: || l_tmp_str
480: || 'ORDER BY MM.msite_id';
481:
482: -- Mini-site and responsibility association (from jtf_msite_resps_b, _tl)
483: OPEN x_msite_resps_cur FOR 'SELECT MM.msite_id, MRB.msite_resp_id, '
484: || 'MRB.responsibility_id, MRB.application_id, MRTL.language, '
485: || 'MRTL.display_name '
486: || 'FROM jtf_msite_resps_b MRB, jtf_msite_resps_tl MRTL, '

Line 486: || 'FROM jtf_msite_resps_b MRB, jtf_msite_resps_tl MRTL, '

482: -- Mini-site and responsibility association (from jtf_msite_resps_b, _tl)
483: OPEN x_msite_resps_cur FOR 'SELECT MM.msite_id, MRB.msite_resp_id, '
484: || 'MRB.responsibility_id, MRB.application_id, MRTL.language, '
485: || 'MRTL.display_name '
486: || 'FROM jtf_msite_resps_b MRB, jtf_msite_resps_tl MRTL, '
487: || 'jtf_msites_b MM WHERE '
488: || 'MM.msite_id = MRB.msite_id AND '
489: || 'MRB.msite_resp_id = MRTL.msite_resp_id AND '
490: || 'sysdate BETWEEN MRB.start_date_active AND NVL(MRB.end_date_active,sysdate) AND '