APPS.BEN_COBRA_REQUIREMENTS dependencies on PER_ALL_PEOPLE_F

Line 254: l_registered_disabled_flag per_all_people_f.registered_disabled_flag%type;

250: ,p_business_group_id in number) return boolean is
251: --
252: l_proc varchar2(80) := g_package||'.chk_dsbld';
253: l_dsbld boolean := false;
254: l_registered_disabled_flag per_all_people_f.registered_disabled_flag%type;
255: l_new_val ben_per_info_chg_cs_ler_f.new_val%type;
256: --
257: cursor c_chk_dsbld
258: is

Line 260: from per_all_people_f per

256: --
257: cursor c_chk_dsbld
258: is
259: select per.registered_disabled_flag
260: from per_all_people_f per
261: where per.person_id = p_person_id
262: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
263: per.effective_start_date and per.effective_end_date
264: and per.business_group_id = p_business_group_id;

Line 270: where psl.source_table = 'PER_ALL_PEOPLE_F'

266: cursor c_chk_dsblty_criteria
267: is
268: select psl.new_val
269: from ben_per_info_chg_cs_ler_f psl
270: where psl.source_table = 'PER_ALL_PEOPLE_F'
271: and psl.source_column = 'REGISTERED_DISABLED_FLAG'
272: and nvl(p_lf_evt_ocrd_dt, p_effective_date)
273: between psl.effective_start_date and psl.effective_end_date
274: and psl.business_group_id = p_business_group_id;