DBA Data[Home] [Help]

APPS.BEN_PER_ASG_ELIG dependencies on BEN_ELIG_OBJ_F

Line 38: from ben_elig_obj_f

34: l_proc varchar2(61) := g_proc||'.internal_eligible';
35:
36: cursor c_chk_ebo is
37: select null
38: from ben_elig_obj_f
39: where elig_obj_id = p_elig_obj_id
40: and p_effective_date between effective_start_date
41: and effective_end_date;
42:

Line 167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');

163: fetch c_chk_ebo into l_dummy;
164: if c_chk_ebo%notfound then
165: close c_chk_ebo;
166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');
168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
169: hr_utility.raise_error;
170: end if;
171: close c_chk_ebo;