[Home] [Help]
143: where abr.'||p_col_name||'= :5
144: and abr.acty_base_rt_id = avr.acty_base_rt_id
145: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
146: exists (select null
147: from ben_comp_lvl_rt_f clr,
148: ben_acty_base_rt_f abr,
149: ben_acty_vrbl_rt_f avr
150: where abr.'||p_col_name||'= :6
151: and abr.acty_base_rt_id = avr.acty_base_rt_id
198: where apr.'||p_col_name||'= :5
199: and apr.actl_prem_id = apv.actl_prem_id
200: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
201: exists (select null
202: from ben_comp_lvl_rt_f clr,
203: ben_actl_prem_f apr,
204: ben_actl_prem_vrbl_rt_f apv
205: where apr.'||p_col_name||'= :6
206: and apr.actl_prem_id = apv.actl_prem_id
253: where ccm.'||p_col_name||'= :5
254: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
255: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
256: exists (select null
257: from ben_comp_lvl_rt_f clr,
258: ben_cvg_amt_calc_mthd_f ccm,
259: ben_bnft_vrbl_rt_f bvr
260: where ccm.'||p_col_name||'= :6
261: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
305: where abr.'||p_col_name||'= :5
306: and abr.acty_base_rt_id = avr.acty_base_rt_id
307: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
308: not exists (select null
309: from ben_comp_lvl_rt_f clr,
310: ben_acty_base_rt_f abr,
311: ben_acty_vrbl_rt_f avr
312: where abr.'||p_col_name||'= :6
313: and abr.acty_base_rt_id = avr.acty_base_rt_id
354: where apr.'||p_col_name||' = :11
355: and apr.actl_prem_id = apv.actl_prem_id
356: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
357: not exists (select null
358: from ben_comp_lvl_rt_f clr,
359: ben_actl_prem_f apr,
360: ben_actl_prem_vrbl_rt_f apv
361: where apr.'||p_col_name||'= :12
362: and apr.actl_prem_id = apv.actl_prem_id
404: where ccm.'||p_col_name||'= :17
405: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
406: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
407: not exists (select null
408: from ben_comp_lvl_rt_f clr,
409: ben_cvg_amt_calc_mthd_f ccm,
410: ben_bnft_vrbl_rt_f bvr
411: where ccm.'||p_col_name||'= :18
412: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
599: where abr.pgm_id = i.pgm_id
600: and abr.acty_base_rt_id = avr.acty_base_rt_id
601: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
602: and not exists (select null
603: from ben_comp_lvl_rt_f clr,
604: ben_acty_base_rt_f abr,
605: ben_acty_vrbl_rt_f avr
606: where abr.pgm_id = i.pgm_id
607: and abr.acty_base_rt_id = avr.acty_base_rt_id
650: where abr.pl_id = i.pl_id
651: and abr.acty_base_rt_id = avr.acty_base_rt_id
652: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
653: and not exists (select null
654: from ben_comp_lvl_rt_f clr,
655: ben_acty_base_rt_f abr,
656: ben_acty_vrbl_rt_f avr
657: where abr.pl_id = i.pl_id
658: and abr.acty_base_rt_id = avr.acty_base_rt_id
692: where apr.pl_id = i.pl_id
693: and apr.actl_prem_id = apv.actl_prem_id
694: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
695: and not exists (select null
696: from ben_comp_lvl_rt_f clr,
697: ben_actl_prem_f apr,
698: ben_actl_prem_vrbl_rt_f apv
699: where apr.pl_id = i.pl_id
700: and apr.actl_prem_id = apv.actl_prem_id
734: where ccm.pl_id = i.pl_id
735: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
736: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
737: and not exists (select null
738: from ben_comp_lvl_rt_f clr,
739: ben_cvg_amt_calc_mthd_f ccm,
740: ben_bnft_vrbl_rt_f bvr
741: where ccm.pl_id = i.pl_id
742: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
785: where abr.plip_id = i.plip_id
786: and abr.acty_base_rt_id = avr.acty_base_rt_id
787: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
788: and not exists (select null
789: from ben_comp_lvl_rt_f clr,
790: ben_acty_base_rt_f abr,
791: ben_acty_vrbl_rt_f avr
792: where abr.plip_id = i.plip_id
793: and abr.acty_base_rt_id = avr.acty_base_rt_id
827: where ccm.plip_id = i.plip_id
828: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
829: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
830: and not exists (select null
831: from ben_comp_lvl_rt_f clr,
832: ben_cvg_amt_calc_mthd_f ccm,
833: ben_bnft_vrbl_rt_f bvr
834: where ccm.plip_id = i.plip_id
835: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
878: where abr.ptip_id = i.ptip_id
879: and abr.acty_base_rt_id = avr.acty_base_rt_id
880: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
881: and not exists (select null
882: from ben_comp_lvl_rt_f clr,
883: ben_acty_base_rt_f abr,
884: ben_acty_vrbl_rt_f avr
885: where abr.ptip_id = i.ptip_id
886: and abr.acty_base_rt_id = avr.acty_base_rt_id
929: where abr.oipl_id = i.oipl_id
930: and abr.acty_base_rt_id = avr.acty_base_rt_id
931: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
932: and not exists (select null
933: from ben_comp_lvl_rt_f clr,
934: ben_acty_base_rt_f abr,
935: ben_acty_vrbl_rt_f avr
936: where abr.oipl_id = i.oipl_id
937: and abr.acty_base_rt_id = avr.acty_base_rt_id
971: where apr.oipl_id = i.oipl_id
972: and apr.actl_prem_id = apv.actl_prem_id
973: and apv.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
974: and not exists (select null
975: from ben_comp_lvl_rt_f clr,
976: ben_actl_prem_f apr,
977: ben_actl_prem_vrbl_rt_f apv
978: where apr.oipl_id = i.oipl_id
979: and apr.actl_prem_id = apv.actl_prem_id
1013: where ccm.oipl_id = i.oipl_id
1014: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1015: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1016: and not exists (select null
1017: from ben_comp_lvl_rt_f clr,
1018: ben_cvg_amt_calc_mthd_f ccm,
1019: ben_bnft_vrbl_rt_f bvr
1020: where ccm.oipl_id = i.oipl_id
1021: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id