APPS.BEN_QIG_BUS dependencies on HR_LOOKUPS

Line 128: from hr_lookups h1

124: l_dummy varchar2(1);
125: l_exists varchar2(1);
126: --
127: cursor c1 is select null
128: from hr_lookups h1
129: where h1.lookup_type = 'BEN_CWB_QUAR_IN_GRD'
130: and h1.lookup_code = p_quar_in_grade_cd
131: and p_effective_date
132: between nvl(h1.start_date_active, p_effective_date)

Line 161: -- check if quar_in_grade_cd value exists in hr_lookups table

157: and nvl(p_quar_in_grade_cd,hr_api.g_varchar2)
158: <> nvl(ben_qig_shd.g_old_rec.quar_in_grade_cd,hr_api.g_varchar2)
159: or not l_api_updating) then
160: --
161: -- check if quar_in_grade_cd value exists in hr_lookups table
162: --
163: open c1;
164: --
165: fetch c1 into l_dummy;

Line 252: if hr_api.not_exists_in_hr_lookups

248: --
249: -- check if value of lookup falls within lookup type.
250: --
251: --
252: if hr_api.not_exists_in_hr_lookups
253: (p_lookup_type => 'YES_NO',
254: p_lookup_code => p_excld_flag,
255: p_effective_date => p_effective_date) then
256: --