DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_OIPLIP_F

Line 775: from ben_oiplip_f oiplip,

771: p_effective_date between
772: pl.effective_start_date and pl.effective_end_date;
773: cursor c_oiplip(p_effective_date date) is
774: select pl.pl_typ_id , pl.pl_id
775: from ben_oiplip_f oiplip,
776: ben_oipl_f oipl,
777: ben_pl_f pl
778: where oiplip.oiplip_id=p_oiplip_id and
779: oiplip.business_group_id=p_business_group_id and

Line 5531: from ben_oiplip_f oiplip

5527: and plip.effective_end_date;
5528: --
5529: cursor c_oipl is
5530: select oipl_id
5531: from ben_oiplip_f oiplip
5532: where oiplip.oiplip_id = p_oiplip_id
5533: and nvl(g_fonm_cvg_strt_dt,p_effective_date)
5534: between oiplip.effective_start_date
5535: and oiplip.effective_end_date;