APPS.BEN_DETERMINE_DATE dependencies on BEN_OIPL_F

Line 79: ben_oipl_f cop

75: select yrp.start_date,
76: yrp.end_date
77: from ben_yr_perd yrp,
78: ben_popl_yr_perd cpy,
79: ben_oipl_f cop
80: where cpy.pl_id = cop.pl_id
81: and cop.oipl_id = p_oipl_id
82: and cpy.yr_perd_id = yrp.yr_perd_id
83: and l_effective_date

Line 404: ben_oipl_f cop

400: cursor c_oipl_next_popl_yr is
401: select yrp.start_date, yrp.end_date
402: from ben_yr_perd yrp,
403: ben_popl_yr_perd cpy,
404: ben_oipl_f cop
405: where cpy.pl_id = cop.pl_id
406: and cop.oipl_id = p_oipl_id
407: and cpy.yr_perd_id = yrp.yr_perd_id
408: and l_effective_date < yrp.start_date

Line 671: from ben_oipl_f oipl

667: and epe.per_in_ler_id = pil.per_in_ler_id;
668: --
669: cursor c_opt(l_oipl_id number) is
670: select opt_id
671: from ben_oipl_f oipl
672: where oipl_id = l_oipl_id
673: and business_group_id = p_business_group_id
674: and nvl(l_lf_evt_ocrd_dt,p_effective_date)
675: between oipl.effective_start_date

Line 873: ben_oipl_f cop

869: select yrp.lmtn_yr_strt_dt,
870: yrp.lmtn_yr_end_dt
871: from ben_yr_perd yrp,
872: ben_popl_yr_perd cpy,
873: ben_oipl_f cop
874: where cpy.pl_id = cop.pl_id
875: and cop.oipl_id = l_oipl_id
876: and cpy.yr_perd_id = yrp.yr_perd_id
877: and nvl(l_lf_evt_ocrd_dt,p_effective_date)

Line 7480: from ben_oipl_f oipl, ben_opt_f opt

7476: (c_oipl_id in number
7477: ,c_effective_date in date)
7478: is
7479: select opt.name
7480: from ben_oipl_f oipl, ben_opt_f opt
7481: where oipl.business_group_id=p_business_group_id
7482: and oipl.opt_id = opt.opt_id and oipl.oipl_id = c_oipl_id
7483: and c_effective_date between oipl.effective_start_date and oipl.effective_end_date
7484: and c_effective_date between opt.effective_start_date and opt.effective_end_date;