[Home] [Help]
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
304: ptip.pl_typ_id,
305: nvl(plip.pl_id, plip2.pl_id) pl_id,
306: oipl.opt_id
307: from ben_bnft_prvdr_pool_f bpp, ben_ptip_f ptip, ben_plip_f plip,
308: ben_oipl_f oipl, ben_oiplip_f oiplip, ben_plip_f plip2
309: where p_effective_date between
310: bpp.effective_start_date and
311: bpp.effective_end_date and
312: bpp.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
729: select 'x'
730: from ben_prtt_enrt_rslt_f per,
731: ben_pl_f pl,
732: ben_ptip_f pt,
733: ben_oipl_f oipl,
734: ben_opt_f opt
735: where per.person_id=p_person_id and
736: per.business_group_id=p_epe_rec.business_group_id and
737: p_effective_date between
761: select 'x'
762: from ben_prtt_enrt_rslt_f per,
763: ben_pl_f pl,
764: ben_optip_f otp,
765: ben_oipl_f oipl
766: where per.person_id=p_person_id and
767: per.business_group_id=p_epe_rec.business_group_id and
768: p_effective_date between
769: per.effective_start_date and per.effective_end_date and
3532: ben_prtt_rt_val prv,
3533: ben_prtt_enrt_rslt_f rslt,
3534: per_all_assignments_f asg,
3535: hr_locations_all loc,
3536: ben_oipl_f oipl
3537: where
3538: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3539: prr.business_group_id=p_business_group_id and
3540: p_effective_date between
3609: ben_prtt_rt_val prv,
3610: ben_prtt_enrt_rslt_f rslt,
3611: per_all_assignments_f asg,
3612: hr_locations_all loc,
3613: ben_oipl_f oipl
3614: where
3615: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3616: prr.business_group_id=p_business_group_id and
3617: p_effective_date between
5668: ben_prtt_rt_val prv,
5669: ben_prtt_enrt_rslt_f rslt,
5670: per_all_assignments_f asg,
5671: hr_locations_all loc,
5672: ben_oipl_f oipl
5673: where
5674: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
5675: prr.business_group_id=p_business_group_id and
5676: p_effective_date between