DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on FND_LOOKUP_VALUES

Line 1150: from fnd_lookup_values

1146: p_person_language in varchar2)
1147: return VARCHAR2 is
1148: cursor csr_label_meaning is
1149: select 1 ord, meaning
1150: from fnd_lookup_values
1151: where lookup_type = p_lookup_type
1152: and lookup_code = p_lookup_code
1153: and ( ( p_person_language is null and language = 'US' ) or
1154: ( p_person_language is not null and language = p_person_language ) )

Line 1157: from fnd_lookup_values

1153: and ( ( p_person_language is null and language = 'US' ) or
1154: ( p_person_language is not null and language = p_person_language ) )
1155: union all
1156: select 2 ord, meaning
1157: from fnd_lookup_values
1158: where lookup_type = p_lookup_type
1159: and lookup_code = p_lookup_code
1160: and ( language = 'US' and p_person_language is not null
1161: and language <> p_person_language )