APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITES_TL

Line 156: FROM ibe_msite_languages a, ibe_msites_tl b

152: AND site_type = 'I';
153:
154: OPEN x_name_cur FOR SELECT a.language_code,
155: b.msite_name, b.msite_description
156: FROM ibe_msite_languages a, ibe_msites_tl b
157: WHERE a.language_code = b.language
158: AND b.msite_id = a.msite_id
159: AND b.msite_id = l_msite_id;
160:

Line 763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

759: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
760: FROM(select distinct to_number(t.column_value) as msite_id
761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
762: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
764: WHERE L.language_code = TL.language
765: AND L.msite_id = MM.msite_id
766: AND TL.msite_id = MM.msite_id
767: AND MM.msite_id = v.msite_id