DBA Data[Home] [Help]

APPS.PAY_INPUT_VALUES_PKG dependencies on FND_LOOKUP_VALUES

Line 1206: from fnd_lookup_values

1202: if (upper(l_name) = 'PAY VALUE') then
1203: begin
1204: select meaning
1205: into l_tl_name
1206: from fnd_lookup_values
1207: where lookup_type = 'NAME_TRANSLATIONS'
1208: and lookup_code = 'PAY VALUE'
1209: and language = c_lang_rec.language_code;
1210: exception

Line 1220: from fnd_lookup_values

1216: -- meanings are unique so where already used use description
1217: begin
1218: select nvl(description,meaning)
1219: into l_tl_name
1220: from fnd_lookup_values
1221: where lookup_type = 'NAME_TRANSLATIONS'
1222: and upper(l_name) like lookup_code
1223: and language = c_lang_rec.language_code
1224: and rownum = 1;

Line 1420: from fnd_lookup_values

1416: if (upper(P_NAME) = 'PAY VALUE') then
1417: begin
1418: select meaning
1419: into l_tl_name
1420: from fnd_lookup_values
1421: where lookup_type = 'NAME_TRANSLATIONS'
1422: and lookup_code = 'PAY VALUE'
1423: and language = userenv('LANG');
1424: exception