DBA Data[Home] [Help]

APPS.PYCADAR_PKG dependencies on FND_LOOKUP_VALUES

Line 1120: from fnd_lookup_values

1116: p_person_language in varchar2)
1117: return VARCHAR2 is
1118: cursor csr_label_meaning is
1119: select 1 ord, meaning
1120: from fnd_lookup_values
1121: where lookup_type = p_lookup_type
1122: and lookup_code = p_lookup_code
1123: and ( ( p_person_language is null and language = 'US' ) or
1124: ( p_person_language is not null and language = p_person_language ) )

Line 1127: from fnd_lookup_values

1123: and ( ( p_person_language is null and language = 'US' ) or
1124: ( p_person_language is not null and language = p_person_language ) )
1125: union all
1126: select 2 ord, meaning
1127: from fnd_lookup_values
1128: where lookup_type = p_lookup_type
1129: and lookup_code = p_lookup_code
1130: and ( language = 'US' and p_person_language is not null
1131: and language <> p_person_language )