APPS.BEN_PROVIDER_POOLS dependencies on BEN_OIPL_F

Line 150: to ben_oipl_f table.

146: modified to select row based on p_effective_date
147: 26-Oct-01 kmahendr 115.61 bug#2077743-in cursor c_prv order by rt_strt_dt desc added to
148: fetch the last rate row.
149: 30-Oct-01 pbodla 115.62 bug#1931485-modified cusor c_rollovers to outerjoin
150: to ben_oipl_f table.
151: 02-Nov-01 kmahendr 115.63 cursors in person_enrolled_in_choice modified to look for
152: effective_end_date = eot
153: 09-Jan-02 kmahendr 115.64 Added a cursor c_enrt_rt to get the acty_base_rt_id for
154: getting the ledger entries thro cursor c_bnft_prvdd_ldgr_2

Line 290: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2

286: ptip.pl_typ_id,
287: nvl(plip.pl_id, plip2.pl_id) pl_id,
288: oipl.opt_id
289: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
290: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
291: where p_effective_date between
292: bpp.effective_start_date and
293: bpp.effective_end_date and
294: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and

Line 715: ben_oipl_f oipl,

711: select 'x'
712: from ben_prtt_enrt_rslt_f per,
713: ben_pl_f pl,
714: ben_ptip_f pt,
715: ben_oipl_f oipl,
716: ben_opt_f opt
717: where per.person_id=p_person_id and
718: per.business_group_id=p_epe_rec.business_group_id and
719: p_effective_date between

Line 747: ben_oipl_f oipl

743: select 'x'
744: from ben_prtt_enrt_rslt_f per,
745: ben_pl_f pl,
746: ben_optip_f otp,
747: ben_oipl_f oipl
748: where per.person_id=p_person_id and
749: per.business_group_id=p_epe_rec.business_group_id and
750: p_effective_date between
751: per.effective_start_date and per.effective_end_date and

Line 3357: ben_oipl_f oipl

3353: ben_prtt_rt_val prv,
3354: ben_prtt_enrt_rslt_f rslt,
3355: per_all_assignments_f asg,
3356: hr_locations_all loc,
3357: ben_oipl_f oipl
3358: where
3359: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3360: prr.business_group_id=p_business_group_id and
3361: p_effective_date between

Line 3434: ben_oipl_f oipl

3430: ben_prtt_rt_val prv,
3431: ben_prtt_enrt_rslt_f rslt,
3432: per_all_assignments_f asg,
3433: hr_locations_all loc,
3434: ben_oipl_f oipl
3435: where
3436: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3437: prr.business_group_id=p_business_group_id and
3438: p_effective_date between

Line 5495: ben_oipl_f oipl

5491: ben_prtt_rt_val prv,
5492: ben_prtt_enrt_rslt_f rslt,
5493: per_all_assignments_f asg,
5494: hr_locations_all loc,
5495: ben_oipl_f oipl
5496: where
5497: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
5498: prr.business_group_id=p_business_group_id and
5499: p_effective_date between