DBA Data[Home] [Help]

APPS.BEN_GENERATE_DPNT_COMM dependencies on PER_ALL_PEOPLE_F

Line 4276: l_per_rec per_all_people_f%rowtype;

4272: l_max_enrt_cvg_thru_dt date := null;
4273: l_pgm_id number := p_pgm_id;
4274: l_pl_typ_id number := p_pl_typ_id;
4275: --
4276: l_per_rec per_all_people_f%rowtype;
4277: l_prtt_per_rec per_all_people_f%rowtype;
4278: --
4279: -- This cursor gets all the dependents that were de-enrolled
4280: -- due/during this life event and satisfies the HIPAA conditions

Line 4277: l_prtt_per_rec per_all_people_f%rowtype;

4273: l_pgm_id number := p_pgm_id;
4274: l_pl_typ_id number := p_pl_typ_id;
4275: --
4276: l_per_rec per_all_people_f%rowtype;
4277: l_prtt_per_rec per_all_people_f%rowtype;
4278: --
4279: -- This cursor gets all the dependents that were de-enrolled
4280: -- due/during this life event and satisfies the HIPAA conditions
4281: -- and regulation.