APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_OIPL_F

Line 3744: ben_oipl_f cop,

3740: from ben_prtt_enrt_rslt_f pen,
3741: ben_pl_f pln,
3742: ben_pl_regn_f plrg,
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'

Line 3783: ben_oipl_f cop,

3779: select 'Y'
3780: from ben_elig_per_elctbl_chc epe,
3781: ben_per_in_ler pil,
3782: ben_pl_f pln,
3783: ben_oipl_f cop,
3784: ben_opt_f opt
3785: where epe.per_in_ler_id = p_per_in_ler_id
3786: and nvl(epe.pgm_id,-1) = nvl(v_pgm_id,-1)
3787: and epe.pl_typ_id = v_pl_typ_id

Line 3813: ben_oipl_f cop,

3809: v_pl_typ_id in number) is
3810: select 'Y'
3811: from ben_prtt_enrt_rslt_f pen,
3812: ben_pl_f pln,
3813: ben_oipl_f cop,
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