[Home] [Help]
150: where abr.'||p_col_name||'= :6
151: and abr.acty_base_rt_id = avr.acty_base_rt_id
152: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
153: exists (select null
154: from ben_hrs_wkd_in_perd_rt_f hwr,
155: ben_acty_base_rt_f abr,
156: ben_acty_vrbl_rt_f avr
157: where abr.'||p_col_name||'= :7
158: and abr.acty_base_rt_id = avr.acty_base_rt_id
205: where apr.'||p_col_name||'= :6
206: and apr.actl_prem_id = apv.actl_prem_id
207: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
208: exists (select null
209: from ben_hrs_wkd_in_perd_rt_f hwr,
210: ben_actl_prem_f apr,
211: ben_actl_prem_vrbl_rt_f apv
212: where apr.'||p_col_name||'= :7
213: and apr.actl_prem_id = apv.actl_prem_id
260: where ccm.'||p_col_name||'= :6
261: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
262: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
263: exists (select null
264: from ben_hrs_wkd_in_perd_rt_f hwr,
265: ben_cvg_amt_calc_mthd_f ccm,
266: ben_bnft_vrbl_rt_f bvr
267: where ccm.'||p_col_name||'= :7
268: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
312: where abr.'||p_col_name||'= :6
313: and abr.acty_base_rt_id = avr.acty_base_rt_id
314: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
315: not exists (select null
316: from ben_hrs_wkd_in_perd_rt_f hwr,
317: ben_acty_base_rt_f abr,
318: ben_acty_vrbl_rt_f avr
319: where abr.'||p_col_name||'= :7
320: and abr.acty_base_rt_id = avr.acty_base_rt_id
361: where apr.'||p_col_name||'= :12
362: and apr.actl_prem_id = apv.actl_prem_id
363: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
364: not exists (select null
365: from ben_hrs_wkd_in_perd_rt_f hwr,
366: ben_actl_prem_f apr,
367: ben_actl_prem_vrbl_rt_f apv
368: where apr.'||p_col_name||'= :13
369: and apr.actl_prem_id = apv.actl_prem_id
411: where ccm.'||p_col_name||'= :18
412: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
413: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
414: not exists (select null
415: from ben_hrs_wkd_in_perd_rt_f hwr,
416: ben_cvg_amt_calc_mthd_f ccm,
417: ben_bnft_vrbl_rt_f bvr
418: where ccm.'||p_col_name||'= :19
419: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
606: where abr.pgm_id = i.pgm_id
607: and abr.acty_base_rt_id = avr.acty_base_rt_id
608: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
609: and not exists (select null
610: from ben_hrs_wkd_in_perd_rt_f hwr,
611: ben_acty_base_rt_f abr,
612: ben_acty_vrbl_rt_f avr
613: where abr.pgm_id = i.pgm_id
614: and abr.acty_base_rt_id = avr.acty_base_rt_id
657: where abr.pl_id = i.pl_id
658: and abr.acty_base_rt_id = avr.acty_base_rt_id
659: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
660: and not exists (select null
661: from ben_hrs_wkd_in_perd_rt_f hwr,
662: ben_acty_base_rt_f abr,
663: ben_acty_vrbl_rt_f avr
664: where abr.pl_id = i.pl_id
665: and abr.acty_base_rt_id = avr.acty_base_rt_id
699: where apr.pl_id = i.pl_id
700: and apr.actl_prem_id = apv.actl_prem_id
701: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
702: and not exists (select null
703: from ben_hrs_wkd_in_perd_rt_f hwr,
704: ben_actl_prem_f apr,
705: ben_actl_prem_vrbl_rt_f apv
706: where apr.pl_id = i.pl_id
707: and apr.actl_prem_id = apv.actl_prem_id
741: where ccm.pl_id = i.pl_id
742: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
743: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
744: and not exists (select null
745: from ben_hrs_wkd_in_perd_rt_f hwr,
746: ben_cvg_amt_calc_mthd_f ccm,
747: ben_bnft_vrbl_rt_f bvr
748: where ccm.pl_id = i.pl_id
749: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
792: where abr.plip_id = i.plip_id
793: and abr.acty_base_rt_id = avr.acty_base_rt_id
794: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
795: and not exists (select null
796: from ben_hrs_wkd_in_perd_rt_f hwr,
797: ben_acty_base_rt_f abr,
798: ben_acty_vrbl_rt_f avr
799: where abr.plip_id = i.plip_id
800: and abr.acty_base_rt_id = avr.acty_base_rt_id
834: where ccm.plip_id = i.plip_id
835: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
836: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
837: and not exists (select null
838: from ben_hrs_wkd_in_perd_rt_f hwr,
839: ben_cvg_amt_calc_mthd_f ccm,
840: ben_bnft_vrbl_rt_f bvr
841: where ccm.plip_id = i.plip_id
842: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
885: where abr.ptip_id = i.ptip_id
886: and abr.acty_base_rt_id = avr.acty_base_rt_id
887: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
888: and not exists (select null
889: from ben_hrs_wkd_in_perd_rt_f hwr,
890: ben_acty_base_rt_f abr,
891: ben_acty_vrbl_rt_f avr
892: where abr.ptip_id = i.ptip_id
893: and abr.acty_base_rt_id = avr.acty_base_rt_id
936: where abr.oipl_id = i.oipl_id
937: and abr.acty_base_rt_id = avr.acty_base_rt_id
938: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
939: and not exists (select null
940: from ben_hrs_wkd_in_perd_rt_f hwr,
941: ben_acty_base_rt_f abr,
942: ben_acty_vrbl_rt_f avr
943: where abr.oipl_id = i.oipl_id
944: and abr.acty_base_rt_id = avr.acty_base_rt_id
978: where apr.oipl_id = i.oipl_id
979: and apr.actl_prem_id = apv.actl_prem_id
980: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
981: and not exists (select null
982: from ben_hrs_wkd_in_perd_rt_f hwr,
983: ben_actl_prem_f apr,
984: ben_actl_prem_vrbl_rt_f apv
985: where apr.oipl_id = i.oipl_id
986: and apr.actl_prem_id = apv.actl_prem_id
1020: where ccm.oipl_id = i.oipl_id
1021: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1022: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
1023: and not exists (select null
1024: from ben_hrs_wkd_in_perd_rt_f hwr,
1025: ben_cvg_amt_calc_mthd_f ccm,
1026: ben_bnft_vrbl_rt_f bvr
1027: where ccm.oipl_id = i.oipl_id
1028: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id