eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on FND_LOOKUP_VALUES

Line 227: from fnd_lookup_values

223: return varchar2 IS
224:
225: CURSOR get_meaning IS
226: select 1 ord, meaning
227: from fnd_lookup_values
228: where lookup_type = p_lookup_type
229: and lookup_code = p_lookup_code
230: and ( ( p_person_language is null and language = 'US' ) or
231: ( p_person_language is not null and language = p_person_language ) )

Line 234: from fnd_lookup_values

230: and ( ( p_person_language is null and language = 'US' ) or
231: ( p_person_language is not null and language = p_person_language ) )
232: union all
233: select 2 ord, meaning
234: from fnd_lookup_values
235: where lookup_type = p_lookup_type
236: and lookup_code = p_lookup_code
237: and ( language = 'US' and p_person_language is not null
238: and language <> p_person_language )