[Home] [Help]
148: where abr.'||p_col_name||'= :4
149: and abr.acty_base_rt_id = avr.acty_base_rt_id
150: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
151: exists (select null
152: from ben_cmbn_age_los_rt_f cmr,
153: ben_acty_base_rt_f abr,
154: ben_acty_vrbl_rt_f avr
155: where abr.'||p_col_name||'= :5
156: and abr.acty_base_rt_id = avr.acty_base_rt_id
203: where apr.'||p_col_name||' = :4
204: and apr.actl_prem_id = apv.actl_prem_id
205: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
206: exists (select null
207: from ben_cmbn_age_los_rt_f cmr,
208: ben_actl_prem_f apr,
209: ben_actl_prem_vrbl_rt_f apv
210: where apr.'||p_col_name||'= :5
211: and apr.actl_prem_id = apv.actl_prem_id
258: where ccm.'||p_col_name||' = :4
259: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
260: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
261: exists (select null
262: from ben_cmbn_age_los_rt_f cmr,
263: ben_cvg_amt_calc_mthd_f ccm,
264: ben_bnft_vrbl_rt_f bvr
265: where ccm.'||p_col_name||'= :5
266: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
310: where abr.'||p_col_name||' = :4
311: and abr.acty_base_rt_id = avr.acty_base_rt_id
312: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
313: not exists (select null
314: from ben_cmbn_age_los_rt_f cmr,
315: ben_acty_base_rt_f abr,
316: ben_acty_vrbl_rt_f avr
317: where abr.'||p_col_name||'= :5
318: and abr.acty_base_rt_id = avr.acty_base_rt_id
359: where apr.'||p_col_name||' = :10
360: and apr.actl_prem_id = apv.actl_prem_id
361: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
362: not exists (select null
363: from ben_cmbn_age_los_rt_f cmr,
364: ben_actl_prem_f apr,
365: ben_actl_prem_vrbl_rt_f apv
366: where apr.'||p_col_name||' = :11
367: and apr.actl_prem_id = apv.actl_prem_id
409: where ccm.'||p_col_name||' = :16
410: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
411: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
412: not exists (select null
413: from ben_cmbn_age_los_rt_f cmr,
414: ben_cvg_amt_calc_mthd_f ccm,
415: ben_bnft_vrbl_rt_f bvr
416: where ccm.'||p_col_name||'= :17
417: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
604: where abr.pgm_id = i.pgm_id
605: and abr.acty_base_rt_id = avr.acty_base_rt_id
606: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
607: and not exists (select null
608: from ben_cmbn_age_los_rt_f cmr,
609: ben_acty_base_rt_f abr,
610: ben_acty_vrbl_rt_f avr
611: where abr.pgm_id = i.pgm_id
612: and abr.acty_base_rt_id = avr.acty_base_rt_id
655: where abr.pl_id = i.pl_id
656: and abr.acty_base_rt_id = avr.acty_base_rt_id
657: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
658: and not exists (select null
659: from ben_cmbn_age_los_rt_f cmr,
660: ben_acty_base_rt_f abr,
661: ben_acty_vrbl_rt_f avr
662: where abr.pl_id = i.pl_id
663: and abr.acty_base_rt_id = avr.acty_base_rt_id
697: where apr.pl_id = i.pl_id
698: and apr.actl_prem_id = apv.actl_prem_id
699: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
700: and not exists (select null
701: from ben_cmbn_age_los_rt_f cmr,
702: ben_actl_prem_f apr,
703: ben_actl_prem_vrbl_rt_f apv
704: where apr.pl_id = i.pl_id
705: and apr.actl_prem_id = apv.actl_prem_id
739: where ccm.pl_id = i.pl_id
740: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
741: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
742: and not exists (select null
743: from ben_cmbn_age_los_rt_f cmr,
744: ben_cvg_amt_calc_mthd_f ccm,
745: ben_bnft_vrbl_rt_f bvr
746: where ccm.pl_id = i.pl_id
747: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
790: where abr.plip_id = i.plip_id
791: and abr.acty_base_rt_id = avr.acty_base_rt_id
792: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
793: and not exists (select null
794: from ben_cmbn_age_los_rt_f cmr,
795: ben_acty_base_rt_f abr,
796: ben_acty_vrbl_rt_f avr
797: where abr.plip_id = i.plip_id
798: and abr.acty_base_rt_id = avr.acty_base_rt_id
832: where ccm.plip_id = i.plip_id
833: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
834: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
835: and not exists (select null
836: from ben_cmbn_age_los_rt_f cmr,
837: ben_cvg_amt_calc_mthd_f ccm,
838: ben_bnft_vrbl_rt_f bvr
839: where ccm.plip_id = i.plip_id
840: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
883: where abr.ptip_id = i.ptip_id
884: and abr.acty_base_rt_id = avr.acty_base_rt_id
885: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
886: and not exists (select null
887: from ben_cmbn_age_los_rt_f cmr,
888: ben_acty_base_rt_f abr,
889: ben_acty_vrbl_rt_f avr
890: where abr.ptip_id = i.ptip_id
891: and abr.acty_base_rt_id = avr.acty_base_rt_id
934: where abr.oipl_id = i.oipl_id
935: and abr.acty_base_rt_id = avr.acty_base_rt_id
936: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
937: and not exists (select null
938: from ben_cmbn_age_los_rt_f cmr,
939: ben_acty_base_rt_f abr,
940: ben_acty_vrbl_rt_f avr
941: where abr.oipl_id = i.oipl_id
942: and abr.acty_base_rt_id = avr.acty_base_rt_id
976: where apr.oipl_id = i.oipl_id
977: and apr.actl_prem_id = apv.actl_prem_id
978: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
979: and not exists (select null
980: from ben_cmbn_age_los_rt_f cmr,
981: ben_actl_prem_f apr,
982: ben_actl_prem_vrbl_rt_f apv
983: where apr.oipl_id = i.oipl_id
984: and apr.actl_prem_id = apv.actl_prem_id
1018: where ccm.oipl_id = i.oipl_id
1019: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1020: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
1021: and not exists (select null
1022: from ben_cmbn_age_los_rt_f cmr,
1023: ben_cvg_amt_calc_mthd_f ccm,
1024: ben_bnft_vrbl_rt_f bvr
1025: where ccm.oipl_id = i.oipl_id
1026: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id