DBA Data[Home] [Help]

APPS.PAY_JP_DBI_PKG dependencies on FND_LOOKUP_VALUES

Line 79: -- need to refer to fnd_lookup_values

75: p_lookup_code in varchar2) return varchar2
76: is
77: l_meaning hr_lookups.meaning%type;
78: begin
79: -- need to refer to fnd_lookup_values
80: -- because JA japanese dbi suffix should be derived
81: -- when adpatch runs with US lang.
82: select meaning
83: into l_meaning

Line 84: from fnd_lookup_values

80: -- because JA japanese dbi suffix should be derived
81: -- when adpatch runs with US lang.
82: select meaning
83: into l_meaning
84: from fnd_lookup_values
85: where lookup_type = p_lookup_type
86: and view_application_id = 3
87: and lookup_code = p_lookup_code
88: and security_group_id = 0