APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 255: l_new_val ben_per_info_chg_cs_ler_f.new_val%type;

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
259: select per.registered_disabled_flag

Line 269: from ben_per_info_chg_cs_ler_f psl

265: --
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