APPS.PER_SHT_BUS dependencies on HR_LOOKUPS

Line 127: if hr_api.not_exists_in_hr_lookups

123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: --
127: if hr_api.not_exists_in_hr_lookups
128: (p_lookup_type => p_lookup_type,
129: p_lookup_code => p_system_type_cd,
130: p_effective_date => p_effective_date) then
131: --

Line 178: l_lookup_code hr_lookups.lookup_code%TYPE;

174: p_shared_type_name in Varchar2 ) is
175: --
176: l_proc varchar2(72) := g_package||'chk_duplicate_key';
177: l_shared_type_id number;
178: l_lookup_code hr_lookups.lookup_code%TYPE;
179: --
180: -- Fix for bug 3478716. added upper for shared_type_name in the following cursor.
181: --
182: cursor c1 is select shared_type_id