DBA Data[Home] [Help]

APPS.PER_NL_QH_TAX dependencies on HR_LOOKUPS

Line 63: l_lookup_meaning hr_lookups.meaning%type;

59: ) is
60: l_proc varchar2(72) := g_package||'nl_tax_query';
61:
62: Function nl_mand_lookup_meanings(p_lookup_type in varchar2, p_lookup_code in varchar2) return varchar2 is
63: l_lookup_meaning hr_lookups.meaning%type;
64: begin
65: select meaning
66: into l_lookup_meaning
67: from hr_lookups

Line 67: from hr_lookups

63: l_lookup_meaning hr_lookups.meaning%type;
64: begin
65: select meaning
66: into l_lookup_meaning
67: from hr_lookups
68: where lookup_type = p_lookup_type
69: and lookup_code = p_lookup_code;
70: return l_lookup_meaning;
71: exception

Line 80: l_lookup_meaning hr_lookups.meaning%type;

76: return l_lookup_meaning;
77: end;
78:
79: Function nl_lookup_meanings(p_lookup_type in varchar2, p_lookup_code in varchar2) return varchar2 is
80: l_lookup_meaning hr_lookups.meaning%type;
81: begin
82: select meaning
83: into l_lookup_meaning
84: from hr_lookups

Line 84: from hr_lookups

80: l_lookup_meaning hr_lookups.meaning%type;
81: begin
82: select meaning
83: into l_lookup_meaning
84: from hr_lookups
85: where lookup_type = p_lookup_type
86: and lookup_code = p_lookup_code;
87: return l_lookup_meaning;
88: exception