DBA Data[Home] [Help]

APPS.BEN_DET_ENRT_RATES dependencies on BEN_OIPL_F

Line 149: from ben_oipl_f oipl

145: and abr.business_group_id = pen1.business_group_id
146: and abr.context_pl_id = pen.pl_id
147: and ( ( pen.oipl_id is not null
148: and exists ( select null
149: from ben_oipl_f oipl
150: where oipl.oipl_id = pen.oipl_id
151: and oipl.business_group_id = pen.business_group_id
152: and c_effective_date
153: between oipl.effective_start_date and oipl.effective_end_date