DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on FND_LOOKUP_VALUES

Line 237: from fnd_lookup_values

233: return varchar2 IS
234:
235: CURSOR get_meaning IS
236: select 1 ord, meaning
237: from fnd_lookup_values
238: where lookup_type = p_lookup_type
239: and lookup_code = p_lookup_code
240: and ( ( p_person_language is null and language = 'US' ) or
241: ( p_person_language is not null and language = p_person_language ) )

Line 244: from fnd_lookup_values

240: and ( ( p_person_language is null and language = 'US' ) or
241: ( p_person_language is not null and language = p_person_language ) )
242: union all
243: select 2 ord, meaning
244: from fnd_lookup_values
245: where lookup_type = p_lookup_type
246: and lookup_code = p_lookup_code
247: and ( language = 'US' and p_person_language is not null
248: and language <> p_person_language )