DBA Data[Home] [Help]

APPS.PAY_JP_DBI_PKG dependencies on FND_LOOKUP_VALUES

Line 84: -- need to refer to fnd_lookup_values

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

Line 89: from fnd_lookup_values

85: -- because JA japanese dbi suffix should be derived
86: -- when adpatch runs with US lang.
87: select meaning
88: into l_meaning
89: from fnd_lookup_values
90: where lookup_type = p_lookup_type
91: and view_application_id = 3
92: and lookup_code = p_lookup_code
93: and security_group_id = 0