[Home] [Help]
155: where abr.'||p_col_name||'= :5
156: and abr.acty_base_rt_id = avr.acty_base_rt_id
157: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
158: exists (select null
159: from ben_comp_lvl_rt_f clr,
160: ben_acty_base_rt_f abr,
161: ben_acty_vrbl_rt_f avr
162: where abr.'||p_col_name||'= :6
163: and abr.acty_base_rt_id = avr.acty_base_rt_id
210: where apr.'||p_col_name||'= :5
211: and apr.actl_prem_id = apv.actl_prem_id
212: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
213: exists (select null
214: from ben_comp_lvl_rt_f clr,
215: ben_actl_prem_f apr,
216: ben_actl_prem_vrbl_rt_f apv
217: where apr.'||p_col_name||'= :6
218: and apr.actl_prem_id = apv.actl_prem_id
265: where ccm.'||p_col_name||'= :5
266: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
267: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
268: exists (select null
269: from ben_comp_lvl_rt_f clr,
270: ben_cvg_amt_calc_mthd_f ccm,
271: ben_bnft_vrbl_rt_f bvr
272: where ccm.'||p_col_name||'= :6
273: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
317: where abr.'||p_col_name||'= :5
318: and abr.acty_base_rt_id = avr.acty_base_rt_id
319: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
320: not exists (select null
321: from ben_comp_lvl_rt_f clr,
322: ben_acty_base_rt_f abr,
323: ben_acty_vrbl_rt_f avr
324: where abr.'||p_col_name||'= :6
325: and abr.acty_base_rt_id = avr.acty_base_rt_id
366: where apr.'||p_col_name||' = :11
367: and apr.actl_prem_id = apv.actl_prem_id
368: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
369: not exists (select null
370: from ben_comp_lvl_rt_f clr,
371: ben_actl_prem_f apr,
372: ben_actl_prem_vrbl_rt_f apv
373: where apr.'||p_col_name||'= :12
374: and apr.actl_prem_id = apv.actl_prem_id
416: where ccm.'||p_col_name||'= :17
417: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
418: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
419: not exists (select null
420: from ben_comp_lvl_rt_f clr,
421: ben_cvg_amt_calc_mthd_f ccm,
422: ben_bnft_vrbl_rt_f bvr
423: where ccm.'||p_col_name||'= :18
424: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
611: where abr.pgm_id = i.pgm_id
612: and abr.acty_base_rt_id = avr.acty_base_rt_id
613: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
614: and not exists (select null
615: from ben_comp_lvl_rt_f clr,
616: ben_acty_base_rt_f abr,
617: ben_acty_vrbl_rt_f avr
618: where abr.pgm_id = i.pgm_id
619: and abr.acty_base_rt_id = avr.acty_base_rt_id
662: where abr.pl_id = i.pl_id
663: and abr.acty_base_rt_id = avr.acty_base_rt_id
664: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
665: and not exists (select null
666: from ben_comp_lvl_rt_f clr,
667: ben_acty_base_rt_f abr,
668: ben_acty_vrbl_rt_f avr
669: where abr.pl_id = i.pl_id
670: and abr.acty_base_rt_id = avr.acty_base_rt_id
704: where apr.pl_id = i.pl_id
705: and apr.actl_prem_id = apv.actl_prem_id
706: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
707: and not exists (select null
708: from ben_comp_lvl_rt_f clr,
709: ben_actl_prem_f apr,
710: ben_actl_prem_vrbl_rt_f apv
711: where apr.pl_id = i.pl_id
712: and apr.actl_prem_id = apv.actl_prem_id
746: where ccm.pl_id = i.pl_id
747: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
748: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
749: and not exists (select null
750: from ben_comp_lvl_rt_f clr,
751: ben_cvg_amt_calc_mthd_f ccm,
752: ben_bnft_vrbl_rt_f bvr
753: where ccm.pl_id = i.pl_id
754: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
797: where abr.plip_id = i.plip_id
798: and abr.acty_base_rt_id = avr.acty_base_rt_id
799: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
800: and not exists (select null
801: from ben_comp_lvl_rt_f clr,
802: ben_acty_base_rt_f abr,
803: ben_acty_vrbl_rt_f avr
804: where abr.plip_id = i.plip_id
805: and abr.acty_base_rt_id = avr.acty_base_rt_id
839: where ccm.plip_id = i.plip_id
840: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
841: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
842: and not exists (select null
843: from ben_comp_lvl_rt_f clr,
844: ben_cvg_amt_calc_mthd_f ccm,
845: ben_bnft_vrbl_rt_f bvr
846: where ccm.plip_id = i.plip_id
847: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
890: where abr.ptip_id = i.ptip_id
891: and abr.acty_base_rt_id = avr.acty_base_rt_id
892: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
893: and not exists (select null
894: from ben_comp_lvl_rt_f clr,
895: ben_acty_base_rt_f abr,
896: ben_acty_vrbl_rt_f avr
897: where abr.ptip_id = i.ptip_id
898: and abr.acty_base_rt_id = avr.acty_base_rt_id
941: where abr.oipl_id = i.oipl_id
942: and abr.acty_base_rt_id = avr.acty_base_rt_id
943: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
944: and not exists (select null
945: from ben_comp_lvl_rt_f clr,
946: ben_acty_base_rt_f abr,
947: ben_acty_vrbl_rt_f avr
948: where abr.oipl_id = i.oipl_id
949: and abr.acty_base_rt_id = avr.acty_base_rt_id
983: where apr.oipl_id = i.oipl_id
984: and apr.actl_prem_id = apv.actl_prem_id
985: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
986: and not exists (select null
987: from ben_comp_lvl_rt_f clr,
988: ben_actl_prem_f apr,
989: ben_actl_prem_vrbl_rt_f apv
990: where apr.oipl_id = i.oipl_id
991: and apr.actl_prem_id = apv.actl_prem_id
1025: where ccm.oipl_id = i.oipl_id
1026: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1027: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1028: and not exists (select null
1029: from ben_comp_lvl_rt_f clr,
1030: ben_cvg_amt_calc_mthd_f ccm,
1031: ben_bnft_vrbl_rt_f bvr
1032: where ccm.oipl_id = i.oipl_id
1033: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id