APPS.IBW_PAGES_PUB dependencies on FND_LANGUAGES

Line 94: FROM ibw_pages_b M, fnd_languages l, fnd_languages b

90: program_id, program_login_id, program_application_id, request_id)
91: SELECT M.page_id, l.language_code, b.language_code, x_page_name, x_description, M.created_by, M.creation_date,
92: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
93: M.program_id, M.program_login_id, M.program_application_id, M.request_id
94: FROM ibw_pages_b M, fnd_languages l, fnd_languages b
95: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.page_id=x_page_id;
96:
97: dbms_output.put_line('Site area found');
98:

Line 359: FROM IBW_PAGES_TL b, FND_LANGUAGES l

355: b.creation_date, b.last_updated_by, b.last_update_date,
356: b.last_update_login, b.object_version_number, b.program_id,
357: b.program_login_id, b.program_application_id, b.request_id,
358: l.language_code, b.source_lang
359: FROM IBW_PAGES_TL b, FND_LANGUAGES l
360: WHERE l.installed_flag IN ('I', 'B')
361: AND b.LANGUAGE = USERENV ('LANG')
362: AND NOT EXISTS (
363: SELECT NULL