APPS.BEN_GENERATE_DPNT_COMM dependencies on HR_API

Line 1538: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1534: between ctu.effective_start_date
1535: and ctu.effective_end_date
1536: and ctu.cm_typ_id = p_cm_typ_id
1537: and ctu.all_r_any_cd = 'ALL'
1538: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1539: and exists (select null
1540: from ben_pl_bnf_f pbn1,
1541: ben_per_in_ler pil
1542: where pbn1.bnf_person_id = p_rcpent_person_id

Line 1557: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1553: from ben_prtt_enrt_rslt_f pen
1554: where pen.business_group_id = p_business_group_id
1555: and pen.prtt_enrt_rslt_stat_cd is null
1556: and pen.per_in_ler_id = p_per_in_ler_id
1557: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1558: and exists (select null
1559: from ben_pl_bnf_f pbn,
1560: ben_per_in_ler pil
1561: where pbn.bnf_person_id = p_rcpent_person_id

Line 1617: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1613: between ctu.effective_start_date
1614: and ctu.effective_end_date
1615: and ctu.cm_typ_id = p_cm_typ_id
1616: and ctu.all_r_any_cd = 'ALL'
1617: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1618: and exists (select null
1619: from ben_elig_cvrd_dpnt_f pdp,
1620: ben_per_in_ler pil
1621: where pdp.dpnt_person_id = p_rcpent_person_id

Line 1635: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1631: from ben_prtt_enrt_rslt_f pen
1632: where pen.business_group_id = p_business_group_id
1633: and pen.prtt_enrt_rslt_stat_cd is null
1634: and pen.per_in_ler_id = p_per_in_ler_id
1635: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1636: and exists (select null
1637: from ben_elig_cvrd_dpnt_f pdp,
1638: ben_per_in_ler pil
1639: where pdp.dpnt_person_id = p_rcpent_person_id

Line 4294: and pdp.cvg_thru_dt <> hr_api.g_eot

4290: ben_oipl_f cop,
4291: ben_opt_f opt
4292: where pdp.per_in_ler_id = p_per_in_ler_id
4293: and pdp.dpnt_person_id = p_rcpent_person_id
4294: and pdp.cvg_thru_dt <> hr_api.g_eot
4295: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4296: and pen.sspndd_flag = 'N'
4297: and pen.prtt_enrt_rslt_stat_cd is null
4298: and p_effective_date between

Line 4340: and pdp.cvg_thru_dt <> hr_api.g_eot

4336: ben_opt_f opt
4337: where pdp.effective_start_date = p_effective_date
4338: and pdp.dpnt_person_id = p_rcpent_person_id
4339: and pdp.request_id = fnd_global.conc_request_id
4340: and pdp.cvg_thru_dt <> hr_api.g_eot
4341: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4342: and pen.pgm_id = p_pgm_id
4343: and pen.pl_typ_id = p_pl_typ_id
4344: and pen.sspndd_flag = 'N'

Line 4421: and pen.enrt_cvg_thru_dt = hr_api.g_eot

4417: where pen.person_id = p_person_id
4418: and pen.prtt_enrt_rslt_stat_cd is null
4419: and pen.pl_typ_id = l_pl_typ_id
4420: and pen.sspndd_flag = 'N'
4421: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4422: and pen.effective_end_date = hr_api.g_eot
4423: and p_effective_date between pen.effective_start_date
4424: and pen.effective_end_date
4425: and pen.business_group_id = p_business_group_id

Line 4422: and pen.effective_end_date = hr_api.g_eot

4418: and pen.prtt_enrt_rslt_stat_cd is null
4419: and pen.pl_typ_id = l_pl_typ_id
4420: and pen.sspndd_flag = 'N'
4421: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4422: and pen.effective_end_date = hr_api.g_eot
4423: and p_effective_date between pen.effective_start_date
4424: and pen.effective_end_date
4425: and pen.business_group_id = p_business_group_id
4426: and pen.pl_id = pln.pl_id

Line 4460: where pdp.cvg_thru_dt = hr_api.g_eot

4456: ben_prtt_enrt_rslt_f pen,
4457: ben_pl_f pln,
4458: ben_oipl_f cop,
4459: ben_opt_f opt
4460: where pdp.cvg_thru_dt = hr_api.g_eot
4461: and pdp.dpnt_person_id = p_rcpent_person_id
4462: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4463: -- and nvl(pen.pgm_id,-1) = nvl(l_pgm_id,-1) maagrawa(02/11/00)
4464: and pen.pl_typ_id = l_pl_typ_id

Line 4465: and pen.enrt_cvg_thru_dt = hr_api.g_eot

4461: and pdp.dpnt_person_id = p_rcpent_person_id
4462: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
4463: -- and nvl(pen.pgm_id,-1) = nvl(l_pgm_id,-1) maagrawa(02/11/00)
4464: and pen.pl_typ_id = l_pl_typ_id
4465: and pen.enrt_cvg_thru_dt = hr_api.g_eot
4466: and pen.sspndd_flag = 'N'
4467: and pen.prtt_enrt_rslt_stat_cd is null
4468: and p_effective_date between
4469: pdp.effective_start_date and pdp.effective_end_date

Line 4595: if l_max_enrt_cvg_thru_dt = hr_api.g_eot or

4591: -- also get de-enrolled. But in this case, we generate comm. for
4592: -- dpnt. only if they do not reside with the participant.
4593: -- Also send comm., when the prtt. is dead.
4594: --
4595: if l_max_enrt_cvg_thru_dt = hr_api.g_eot or
4596: p_rsds_with_prtt = 'N' or
4597: (p_rsds_with_prtt = 'Y'and l_max_enrt_cvg_thru_dt <> hr_api.g_eot) or
4598: l_prtt_per_rec.date_of_death is not null then
4599: --

Line 4597: (p_rsds_with_prtt = 'Y'and l_max_enrt_cvg_thru_dt <> hr_api.g_eot) or

4593: -- Also send comm., when the prtt. is dead.
4594: --
4595: if l_max_enrt_cvg_thru_dt = hr_api.g_eot or
4596: p_rsds_with_prtt = 'N' or
4597: (p_rsds_with_prtt = 'Y'and l_max_enrt_cvg_thru_dt <> hr_api.g_eot) or
4598: l_prtt_per_rec.date_of_death is not null then
4599: --
4600: l_epe_exists := 'N';
4601: l_crntly_enrd := 'N';

Line 4616: l_max_enrt_cvg_thru_dt <> hr_api.g_eot and

4612: -- If dependent resides with the participant, generate a
4613: -- communication only if the participant is still enrolled.
4614: --
4615: if (p_rsds_with_prtt = 'Y' and
4616: l_max_enrt_cvg_thru_dt <> hr_api.g_eot and
4617: l_prtt_per_rec.date_of_death is null) then
4618: --
4619: -- Check if the participant is still enrolled.
4620: --

Line 4638: l_max_enrt_cvg_thru_dt = hr_api.g_eot or

4634: hr_utility.set_location('l_prtt_crntly_enrd: '||l_prtt_crntly_enrd,40);
4635: -- 3585939
4636: if ( (l_prtt_crntly_enrd = 'Y' or l_prtt_epe_exists = 'Y')
4637: or
4638: l_max_enrt_cvg_thru_dt = hr_api.g_eot or
4639: p_rsds_with_prtt = 'N' or
4640: l_prtt_per_rec.date_of_death is not null) then
4641: --
4642: hr_utility.set_location('No Epe: '||l_proc,40);