[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: /* Bug 10145083: Check for c_effective_date and not p_effective_date*/
570: and c_effective_date between pea.effective_start_date
702: ,b.effective_start_date
703: ,b.effective_end_date
704: ,b.object_version_number
705: from ben_prtt_enrt_actn_f b,
706: ben_per_in_ler pil
707: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
708: and b.business_group_id = p_business_group_id
709: and b.cmpltd_dt is NULL
710: and p_effective_date between b.effective_start_date
807: cursor c_actn_min (c_prtt_enrt_rslt_id number)
808: is
809: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
810: from ben_prtt_enrt_actn_f b,
811: ben_per_in_ler pil
812: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
813: and b.business_group_id = p_business_group_id
814: and b.cmpltd_dt is NULL
815: and b.rqd_flag = 'Y'
1868: cursor c_pen
1869: is
1870: select distinct pen.person_id
1871: from ben_prtt_enrt_rslt_f pen
1872: ,ben_per_in_ler pil
1873: ,ben_prtt_enrt_actn_f actn
1874: where pen.business_group_id = p_business_group_id
1875: and pen.business_group_id = actn.business_group_id
1876: and pen.prtt_enrt_rslt_stat_cd is null
2001: --
2002: benutils.g_benefit_action_id := l_benefit_action_id;
2003: benutils.g_thread_id := 99;
2004: --
2005: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
2006: -- create person actions for the selected people.
2007: --
2008: for l_rec in c_pen
2009: loop