APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_OPT_F

Line 3505: ben_opt_f opt

3501: ben_pl_f pln,
3502: ben_pl_regn_f plrg,
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

Line 3543: ben_opt_f opt

3539: from ben_elig_per_elctbl_chc epe,
3540: ben_per_in_ler pil,
3541: ben_pl_f pln,
3542: ben_oipl_f cop,
3543: ben_opt_f opt
3544: where epe.per_in_ler_id = p_per_in_ler_id
3545: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)
3546: and epe.pl_typ_id = v_pl_typ_id
3547: and epe.elctbl_flag = 'Y'

Line 3573: ben_opt_f opt

3569: select 'Y'
3570: from ben_prtt_enrt_rslt_f pen,
3571: ben_pl_f pln,
3572: ben_oipl_f cop,
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