76: X_REPORT_FORMAT_MAPPING_ID,
77: X_DISPLAY_NAME,
78: L.LANGUAGE_CODE,
79: userenv('LANG')
80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T
84: where T.REPORT_FORMAT_MAPPING_ID = X_REPORT_FORMAT_MAPPING_ID
308: SOURCE_LANG
309: ) select /*+ ORDERED */
310: B.REPORT_FORMAT_MAPPING_ID,
311: B.DISPLAY_NAME,
312: L.LANGUAGE_CODE, B.SOURCE_LANG from PAY_REPORT_FORMAT_MAPPINGS_TL B, FND_LANGUAGES L
313: where L.INSTALLED_FLAG in ('I', 'B')
314: and B.LANGUAGE = userenv('LANG')
315: and not exists
316: (select NULL from PAY_REPORT_FORMAT_MAPPINGS_TL T