APPS.IBE_MINISITERUNTIME_PVT dependencies on IBE_MSITES_TL

Line 421: FROM ibe_msite_languages a, ibe_msites_tl b

417: AND site_type = 'I';
418:
419: OPEN x_name_cur FOR SELECT a.language_code,
420: b.msite_name, b.msite_description
421: FROM ibe_msite_languages a, ibe_msites_tl b
422: WHERE a.language_code = b.language
423: AND b.msite_id = a.msite_id
424: AND b.msite_id = l_msite_id;
425:

Line 1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L

1024: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
1025: FROM(select distinct to_number(t.column_value) as msite_id
1026: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1027: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
1029: WHERE L.language_code = TL.language
1030: AND L.msite_id = MM.msite_id
1031: AND TL.msite_id = MM.msite_id
1032: AND MM.msite_id = v.msite_id