DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_OIPLIP_F

Line 776: from ben_oiplip_f oiplip,

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

Line 5532: from ben_oiplip_f oiplip

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