APPS.BEN_PRR_BUS dependencies on HR_LOOKUPS

Line 131: if hr_api.not_exists_in_hr_lookups

127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: --
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'YES_NO',
133: p_lookup_code => p_excld_flag,
134: p_effective_date => p_effective_date) then
135: --

Line 189: from hr_lookups h1

185: l_dummy varchar2(1);
186: --
187: cursor c1 is
188: select null
189: from hr_lookups h1
190: where h1.lookup_type = 'EMP_INTERVIEW_TYPE'
191: and h1.lookup_code = p_event_type
192: and p_effective_date
193: between nvl(h1.start_date_active, p_effective_date)

Line 278: from hr_lookups h1

274: l_dummy varchar2(1);
275: --
276: cursor c1 is
277: select null
278: from hr_lookups h1
279: where h1.lookup_type = 'PERFORMANCE_RATING'
280: and h1.lookup_code = p_perf_rtng_cd
281: and p_effective_date
282: between nvl(h1.start_date_active, p_effective_date)