APPS.JTF_MINISITERUNTIME_PVT dependencies on JTF_MSITES_TL

Line 147: FROM jtf_msite_languages a, jtf_msites_tl b

143: WHERE msite_id = l_msite_id;
144:
145: OPEN x_name_cur FOR SELECT a.language_code,
146: b.msite_name, b.msite_description
147: FROM jtf_msite_languages a, jtf_msites_tl b
148: WHERE a.language_code = b.language
149: AND b.msite_id = a.msite_id
150: AND b.msite_id = l_msite_id;
151:

Line 459: || 'FROM jtf_msite_languages L, jtf_msites_tl TL, jtf_msites_b MM WHERE '

455:
456: -- Mini-site name and description for all languages
457: OPEN x_name_cur FOR 'SELECT MM.msite_id, L.language_code, TL.msite_name, '
458: || 'TL.msite_description '
459: || 'FROM jtf_msite_languages L, jtf_msites_tl TL, jtf_msites_b MM WHERE '
460: || 'L.language_code = TL.language AND '
461: || 'L.msite_id = MM.msite_id AND '
462: || 'TL.msite_id = MM.msite_id AND '
463: || l_tmp_str