APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_OIPL_F

Line 3504: ben_oipl_f cop,

3500: from ben_prtt_enrt_rslt_f pen,
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'

Line 3542: ben_oipl_f cop,

3538: select 'Y'
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

Line 3572: ben_oipl_f cop,

3568: v_pl_typ_id in number) is
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