[Home] [Help]
136: where abr.'||p_col_name||'= :4
137: and abr.acty_base_rt_id = avr.acty_base_rt_id
138: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
139: exists (select null
140: from ben_cmbn_age_los_rt_f cmr,
141: ben_acty_base_rt_f abr,
142: ben_acty_vrbl_rt_f avr
143: where abr.'||p_col_name||'= :5
144: and abr.acty_base_rt_id = avr.acty_base_rt_id
191: where apr.'||p_col_name||' = :4
192: and apr.actl_prem_id = apv.actl_prem_id
193: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
194: exists (select null
195: from ben_cmbn_age_los_rt_f cmr,
196: ben_actl_prem_f apr,
197: ben_actl_prem_vrbl_rt_f apv
198: where apr.'||p_col_name||'= :5
199: and apr.actl_prem_id = apv.actl_prem_id
246: where ccm.'||p_col_name||' = :4
247: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
248: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
249: exists (select null
250: from ben_cmbn_age_los_rt_f cmr,
251: ben_cvg_amt_calc_mthd_f ccm,
252: ben_bnft_vrbl_rt_f bvr
253: where ccm.'||p_col_name||'= :5
254: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
298: where abr.'||p_col_name||' = :4
299: and abr.acty_base_rt_id = avr.acty_base_rt_id
300: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
301: not exists (select null
302: from ben_cmbn_age_los_rt_f cmr,
303: ben_acty_base_rt_f abr,
304: ben_acty_vrbl_rt_f avr
305: where abr.'||p_col_name||'= :5
306: and abr.acty_base_rt_id = avr.acty_base_rt_id
347: where apr.'||p_col_name||' = :10
348: and apr.actl_prem_id = apv.actl_prem_id
349: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
350: not exists (select null
351: from ben_cmbn_age_los_rt_f cmr,
352: ben_actl_prem_f apr,
353: ben_actl_prem_vrbl_rt_f apv
354: where apr.'||p_col_name||' = :11
355: and apr.actl_prem_id = apv.actl_prem_id
397: where ccm.'||p_col_name||' = :16
398: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
399: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
400: not exists (select null
401: from ben_cmbn_age_los_rt_f cmr,
402: ben_cvg_amt_calc_mthd_f ccm,
403: ben_bnft_vrbl_rt_f bvr
404: where ccm.'||p_col_name||'= :17
405: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
592: where abr.pgm_id = i.pgm_id
593: and abr.acty_base_rt_id = avr.acty_base_rt_id
594: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
595: and not exists (select null
596: from ben_cmbn_age_los_rt_f cmr,
597: ben_acty_base_rt_f abr,
598: ben_acty_vrbl_rt_f avr
599: where abr.pgm_id = i.pgm_id
600: and abr.acty_base_rt_id = avr.acty_base_rt_id
643: where abr.pl_id = i.pl_id
644: and abr.acty_base_rt_id = avr.acty_base_rt_id
645: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
646: and not exists (select null
647: from ben_cmbn_age_los_rt_f cmr,
648: ben_acty_base_rt_f abr,
649: ben_acty_vrbl_rt_f avr
650: where abr.pl_id = i.pl_id
651: and abr.acty_base_rt_id = avr.acty_base_rt_id
685: where apr.pl_id = i.pl_id
686: and apr.actl_prem_id = apv.actl_prem_id
687: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
688: and not exists (select null
689: from ben_cmbn_age_los_rt_f cmr,
690: ben_actl_prem_f apr,
691: ben_actl_prem_vrbl_rt_f apv
692: where apr.pl_id = i.pl_id
693: and apr.actl_prem_id = apv.actl_prem_id
727: where ccm.pl_id = i.pl_id
728: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
729: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
730: and not exists (select null
731: from ben_cmbn_age_los_rt_f cmr,
732: ben_cvg_amt_calc_mthd_f ccm,
733: ben_bnft_vrbl_rt_f bvr
734: where ccm.pl_id = i.pl_id
735: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
778: where abr.plip_id = i.plip_id
779: and abr.acty_base_rt_id = avr.acty_base_rt_id
780: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
781: and not exists (select null
782: from ben_cmbn_age_los_rt_f cmr,
783: ben_acty_base_rt_f abr,
784: ben_acty_vrbl_rt_f avr
785: where abr.plip_id = i.plip_id
786: and abr.acty_base_rt_id = avr.acty_base_rt_id
820: where ccm.plip_id = i.plip_id
821: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
822: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
823: and not exists (select null
824: from ben_cmbn_age_los_rt_f cmr,
825: ben_cvg_amt_calc_mthd_f ccm,
826: ben_bnft_vrbl_rt_f bvr
827: where ccm.plip_id = i.plip_id
828: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
871: where abr.ptip_id = i.ptip_id
872: and abr.acty_base_rt_id = avr.acty_base_rt_id
873: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
874: and not exists (select null
875: from ben_cmbn_age_los_rt_f cmr,
876: ben_acty_base_rt_f abr,
877: ben_acty_vrbl_rt_f avr
878: where abr.ptip_id = i.ptip_id
879: and abr.acty_base_rt_id = avr.acty_base_rt_id
922: where abr.oipl_id = i.oipl_id
923: and abr.acty_base_rt_id = avr.acty_base_rt_id
924: and avr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
925: and not exists (select null
926: from ben_cmbn_age_los_rt_f cmr,
927: ben_acty_base_rt_f abr,
928: ben_acty_vrbl_rt_f avr
929: where abr.oipl_id = i.oipl_id
930: and abr.acty_base_rt_id = avr.acty_base_rt_id
964: where apr.oipl_id = i.oipl_id
965: and apr.actl_prem_id = apv.actl_prem_id
966: and apv.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
967: and not exists (select null
968: from ben_cmbn_age_los_rt_f cmr,
969: ben_actl_prem_f apr,
970: ben_actl_prem_vrbl_rt_f apv
971: where apr.oipl_id = i.oipl_id
972: and apr.actl_prem_id = apv.actl_prem_id
1006: where ccm.oipl_id = i.oipl_id
1007: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1008: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
1009: and not exists (select null
1010: from ben_cmbn_age_los_rt_f cmr,
1011: ben_cvg_amt_calc_mthd_f ccm,
1012: ben_bnft_vrbl_rt_f bvr
1013: where ccm.oipl_id = i.oipl_id
1014: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id