[Home] [Help]
406: ecd.dpnt_person_id,
407: ecd.cvg_strt_dt,
408: ecd.cvg_thru_dt
409: from ben_elig_cvrd_dpnt_f ecd,
410: ben_per_in_ler pil
411: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
412: and ecd.business_group_id = p_business_group_id
413: and p_effective_date between ecd.effective_start_date
414: and ecd.effective_end_date
457: cursor c1
458: is
459: select bnf.prtt_enrt_rslt_id, bnf.bnf_person_id
460: from ben_pl_bnf_f bnf,
461: ben_per_in_ler pil
462: where bnf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
463: and bnf.business_group_id= p_business_group_id
464: and p_effective_date between bnf.effective_start_date
465: and bnf.effective_end_date
502: b.actn_typ_id,
503: a.enrt_ctfn_recd_dt
504: from ben_prtt_enrt_ctfn_prvdd_f a
505: ,ben_prtt_enrt_actn_f b
506: ,ben_per_in_ler pil
507: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
508: and a.business_group_id= p_business_group_Id
509: and p_effective_date between
510: a.effective_start_date and a.effective_start_date
562: ,'N' actn_cd
563: ,pea.effective_start_date
564: ,pea.effective_end_date
565: from ben_prtt_enrt_actn_f pea,
566: ben_per_in_ler pil
567: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
568: and pea.business_group_id = p_business_group_id
569: and p_effective_date between pea.effective_start_date
570: and pea.effective_end_date
697: ,b.effective_start_date
698: ,b.effective_end_date
699: ,b.object_version_number
700: from ben_prtt_enrt_actn_f b,
701: ben_per_in_ler pil
702: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
703: and b.business_group_id = p_business_group_id
704: and b.cmpltd_dt is NULL
705: and p_effective_date between b.effective_start_date
714: cursor c_actn_min (c_prtt_enrt_rslt_id number)
715: is
716: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
717: from ben_prtt_enrt_actn_f b,
718: ben_per_in_ler pil
719: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
720: and b.business_group_id = p_business_group_id
721: and b.cmpltd_dt is NULL
722: and b.rqd_flag = 'Y'
1728: cursor c_pen
1729: is
1730: select distinct pen.person_id
1731: from ben_prtt_enrt_rslt_f pen
1732: ,ben_per_in_ler pil
1733: ,ben_prtt_enrt_actn_f actn
1734: where pen.business_group_id = p_business_group_id
1735: and pen.business_group_id = actn.business_group_id
1736: and pen.prtt_enrt_rslt_stat_cd is null
1861: --
1862: benutils.g_benefit_action_id := l_benefit_action_id;
1863: benutils.g_thread_id := 99;
1864: --
1865: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
1866: -- create person actions for the selected people.
1867: --
1868: for l_rec in c_pen
1869: loop