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 871: ben_oipl_f cop

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

Line 7301: from ben_oipl_f oipl, ben_opt_f opt

7297: (c_oipl_id in number
7298: ,c_effective_date in date)
7299: is
7300: select opt.name
7301: from ben_oipl_f oipl, ben_opt_f opt
7302: where oipl.business_group_id=p_business_group_id
7303: and oipl.opt_id = opt.opt_id and oipl.oipl_id = c_oipl_id
7304: and c_effective_date between oipl.effective_start_date and oipl.effective_end_date
7305: and c_effective_date between opt.effective_start_date and opt.effective_end_date;