APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 3615: ben_prtt_enrt_rslt_f pen,

3611: --
3612: cursor c_per_actnrmdr is
3613: select distinct ppf.person_id
3614: from per_all_people_f ppf,
3615: ben_prtt_enrt_rslt_f pen,
3616: ben_per_in_ler pil,
3617: ben_prtt_enrt_actn_f pea
3618: where (g_parm.person_id is null or
3619: ppf.person_id = g_parm.person_id)

Line 3876: from ben_prtt_enrt_rslt_f pen

3872: --
3873: cursor c_enrt(v_person_id number) is
3874: select pen.pgm_id,
3875: pen.pl_id
3876: from ben_prtt_enrt_rslt_f pen
3877: where pen.person_id = v_person_id
3878: and (g_parm.pgm_id is null or
3879: pen.pgm_id = g_parm.pgm_id)
3880: and ((g_parm.pl_nip_id is null

Line 3900: from ben_prtt_enrt_rslt_f pen,

3896: --
3897: cursor c_dpnt_enrt(v_person_id number) is
3898: select pen.pgm_id,
3899: pen.pl_id
3900: from ben_prtt_enrt_rslt_f pen,
3901: ben_elig_cvrd_dpnt_f pdp
3902: where pdp.dpnt_person_id = v_person_id
3903: and pdp.cvg_thru_dt = hr_api.g_eot
3904: and g_parm.effective_date between

Line 4277: from ben_prtt_enrt_rslt_f pen

4273: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4274: --
4275: and ( (g_parm.elig_enrol_cd = 'ENROL' -- begin ENROL block
4276: and exists (select 's'
4277: from ben_prtt_enrt_rslt_f pen
4278: where pen.person_id = ppf.person_id
4279: and (pen.pgm_id = g_parm.pgm_id)
4280: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and pen.pgm_id is not null)
4281: and pen.sspndd_flag = 'N'

Line 4346: from ben_prtt_enrt_rslt_f pen

4342: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4343: --
4344: and ( (g_parm.elig_enrol_cd = 'ENROL' -- begin ENROL block
4345: and exists (select 's'
4346: from ben_prtt_enrt_rslt_f pen
4347: where pen.person_id = ppf.person_id
4348: and (g_parm.pgm_id is null)
4349: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and pen.pgm_id is null)
4350: and (g_parm.pl_nip_id = pen.pl_id)