APPS.BEN_COBRA_REQUIREMENTS dependencies on PER_ALL_PEOPLE_F

Line 271: l_registered_disabled_flag per_all_people_f.registered_disabled_flag%type;

267: ,p_business_group_id in number) return boolean is
268: --
269: l_proc varchar2(80) := g_package||'.chk_dsbld';
270: l_dsbld boolean := false;
271: l_registered_disabled_flag per_all_people_f.registered_disabled_flag%type;
272: l_new_val ben_per_info_chg_cs_ler_f.new_val%type;
273: --
274: cursor c_chk_dsbld
275: is

Line 277: from per_all_people_f per

273: --
274: cursor c_chk_dsbld
275: is
276: select per.registered_disabled_flag
277: from per_all_people_f per
278: where per.person_id = p_person_id
279: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
280: per.effective_start_date and per.effective_end_date
281: and per.business_group_id = p_business_group_id;

Line 287: where psl.source_table = 'PER_ALL_PEOPLE_F'

283: cursor c_chk_dsblty_criteria
284: is
285: select psl.new_val
286: from ben_per_info_chg_cs_ler_f psl
287: where psl.source_table = 'PER_ALL_PEOPLE_F'
288: and psl.source_column = 'REGISTERED_DISABLED_FLAG'
289: and nvl(p_lf_evt_ocrd_dt, p_effective_date)
290: between psl.effective_start_date and psl.effective_end_date
291: and psl.business_group_id = p_business_group_id;