APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 3673: ben_prtt_enrt_rslt_f pen,

3669: --
3670: cursor c_per_actnrmdr is
3671: select distinct ppf.person_id
3672: from per_all_people_f ppf,
3673: ben_prtt_enrt_rslt_f pen,
3674: ben_per_in_ler pil,
3675: ben_prtt_enrt_actn_f pea
3676: where (g_parm.person_id is null or
3677: ppf.person_id = g_parm.person_id)

Line 3934: from ben_prtt_enrt_rslt_f pen

3930: --
3931: cursor c_enrt(v_person_id number) is
3932: select pen.pgm_id,
3933: pen.pl_id
3934: from ben_prtt_enrt_rslt_f pen
3935: where pen.person_id = v_person_id
3936: and (g_parm.pgm_id is null or
3937: pen.pgm_id = g_parm.pgm_id)
3938: and ((g_parm.pl_nip_id is null

Line 3961: from ben_prtt_enrt_rslt_f pen,

3957: --
3958: cursor c_dpnt_enrt(v_person_id number) is
3959: select pen.pgm_id,
3960: pen.pl_id
3961: from ben_prtt_enrt_rslt_f pen,
3962: ben_elig_cvrd_dpnt_f pdp
3963: where pdp.dpnt_person_id = v_person_id
3964: and pdp.cvg_thru_dt = hr_api.g_eot
3965: and g_parm.effective_date between

Line 4338: from ben_prtt_enrt_rslt_f pen

4334: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4335: --
4336: and ( (g_parm.elig_enrol_cd = 'ENROL' -- begin ENROL block
4337: and exists (select 's'
4338: from ben_prtt_enrt_rslt_f pen
4339: where pen.person_id = ppf.person_id
4340: and (pen.pgm_id = g_parm.pgm_id)
4341: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and pen.pgm_id is not null)
4342: and pen.sspndd_flag = 'N'

Line 4411: from ben_prtt_enrt_rslt_f pen

4407: and g_parm.effective_date between ppu.effective_start_date and ppu.effective_end_date))
4408: --
4409: and ( (g_parm.elig_enrol_cd = 'ENROL' -- begin ENROL block
4410: and exists (select 's'
4411: from ben_prtt_enrt_rslt_f pen
4412: where pen.person_id = ppf.person_id
4413: and (g_parm.pgm_id is null)
4414: and (g_parm.pl_nip_id is not null and g_parm.plan_in_pgm_flag = 'N' and pen.pgm_id is null)
4415: and (g_parm.pl_nip_id = pen.pl_id)