DBA Data[Home] [Help]

APPS.PAY_CA_T4A_REG dependencies on FND_LOOKUP_VALUES

Line 1180: from fnd_lookup_values

1176: p_person_language in varchar2)
1177: return VARCHAR2 is
1178: cursor csr_label_meaning is
1179: select 1 ord, meaning
1180: from fnd_lookup_values
1181: where lookup_type = p_lookup_type
1182: and lookup_code = p_lookup_code
1183: and ( ( p_person_language is null and language = 'US' ) or
1184: ( p_person_language is not null and language = p_person_language ) )

Line 1187: from fnd_lookup_values

1183: and ( ( p_person_language is null and language = 'US' ) or
1184: ( p_person_language is not null and language = p_person_language ) )
1185: union all
1186: select 2 ord, meaning
1187: from fnd_lookup_values
1188: where lookup_type = p_lookup_type
1189: and lookup_code = p_lookup_code
1190: and ( language = 'US' and p_person_language is not null
1191: and language <> p_person_language )