APPS.BEN_GENERATE_COMMUNICATIONS dependencies on HR_API

Line 2198: and pen.enrt_cvg_thru_dt < hr_api.g_eot

2194: between ctu.effective_start_date
2195: and ctu.effective_end_date
2196: and ctu.cm_typ_id = p_cm_typ_id
2197: and ctu.all_r_any_cd = 'ALL'
2198: and pen.enrt_cvg_thru_dt < hr_api.g_eot
2199: and pen.prtt_enrt_rslt_stat_cd is null;
2200: --
2201: cursor c2 is
2202: select null

Line 2208: and pen.enrt_cvg_thru_dt < hr_api.g_eot

2204: ben_per_in_ler pil
2205: where pen.business_group_id = p_business_group_id
2206: and pen.per_in_ler_id = p_per_in_ler_id
2207: and pen.per_in_ler_id = pil.per_in_ler_id -- 5926672 join to pil
2208: and pen.enrt_cvg_thru_dt < hr_api.g_eot
2209: and (
2210: (l_effective_date
2211: between pen.effective_start_date -- 5926672 chnged to pil
2212: and pen.effective_end_date

Line 3747: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

3743: ben_regn_f regn,
3744: ben_oipl_f cop,
3745: ben_opt_f opt
3746: where pen.per_in_ler_id = p_per_in_ler_id
3747: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
3748: and pen.sspndd_flag = 'N'
3749: and pen.prtt_enrt_rslt_stat_cd is null
3750: --8818355
3751: --and p_effective_date between

Line 3818: and pen.enrt_cvg_thru_dt = hr_api.g_eot

3814: ben_opt_f opt
3815: where pen.person_id = p_person_id
3816: -- and nvl(pen.pgm_id,-1) = nvl(v_pgm_id,-1) maagrawa (02/11/00)
3817: and pen.pl_typ_id = v_pl_typ_id
3818: and pen.enrt_cvg_thru_dt = hr_api.g_eot
3819: --8818355
3820: and pen.effective_end_date = hr_api.g_eot
3821: and pen.sspndd_flag = 'N'
3822: and pen.prtt_enrt_rslt_stat_cd is null

Line 3820: and pen.effective_end_date = hr_api.g_eot

3816: -- and nvl(pen.pgm_id,-1) = nvl(v_pgm_id,-1) maagrawa (02/11/00)
3817: and pen.pl_typ_id = v_pl_typ_id
3818: and pen.enrt_cvg_thru_dt = hr_api.g_eot
3819: --8818355
3820: and pen.effective_end_date = hr_api.g_eot
3821: and pen.sspndd_flag = 'N'
3822: and pen.prtt_enrt_rslt_stat_cd is null
3823: --8818355
3824: --and p_effective_date between