APPS.BEN_GENERATE_COMMUNICATIONS dependencies on HR_API

Line 1959: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1955: between ctu.effective_start_date
1956: and ctu.effective_end_date
1957: and ctu.cm_typ_id = p_cm_typ_id
1958: and ctu.all_r_any_cd = 'ALL'
1959: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1960: and pen.prtt_enrt_rslt_stat_cd is null;
1961: --
1962: cursor c2 is
1963: select null

Line 1969: and pen.enrt_cvg_thru_dt < hr_api.g_eot

1965: ben_per_in_ler pil
1966: where pen.business_group_id = p_business_group_id
1967: and pen.per_in_ler_id = p_per_in_ler_id
1968: and pen.per_in_ler_id = pil.per_in_ler_id -- 5926672 join to pil
1969: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1970: and (
1971: (l_effective_date
1972: between pen.effective_start_date -- 5926672 chnged to pil
1973: and pen.effective_end_date

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

3503: ben_regn_f regn,
3504: ben_oipl_f cop,
3505: ben_opt_f opt
3506: where pen.per_in_ler_id = p_per_in_ler_id
3507: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
3508: and pen.sspndd_flag = 'N'
3509: and pen.prtt_enrt_rslt_stat_cd is null
3510: and p_effective_date between
3511: pen.effective_start_date and pen.effective_end_date

Line 3577: and pen.enrt_cvg_thru_dt = hr_api.g_eot

3573: ben_opt_f opt
3574: where pen.person_id = p_person_id
3575: -- and nvl(pen.pgm_id,-1) = nvl(v_pgm_id,-1) maagrawa (02/11/00)
3576: and pen.pl_typ_id = v_pl_typ_id
3577: and pen.enrt_cvg_thru_dt = hr_api.g_eot
3578: and pen.sspndd_flag = 'N'
3579: and pen.prtt_enrt_rslt_stat_cd is null
3580: and p_effective_date between
3581: pen.effective_start_date and pen.effective_end_date