[Home] [Help]
162: where abr.'||p_col_name||'= :6
163: and abr.acty_base_rt_id = avr.acty_base_rt_id
164: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
165: exists (select null
166: from ben_hrs_wkd_in_perd_rt_f hwr,
167: ben_acty_base_rt_f abr,
168: ben_acty_vrbl_rt_f avr
169: where abr.'||p_col_name||'= :7
170: and abr.acty_base_rt_id = avr.acty_base_rt_id
217: where apr.'||p_col_name||'= :6
218: and apr.actl_prem_id = apv.actl_prem_id
219: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
220: exists (select null
221: from ben_hrs_wkd_in_perd_rt_f hwr,
222: ben_actl_prem_f apr,
223: ben_actl_prem_vrbl_rt_f apv
224: where apr.'||p_col_name||'= :7
225: and apr.actl_prem_id = apv.actl_prem_id
272: where ccm.'||p_col_name||'= :6
273: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
274: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
275: exists (select null
276: from ben_hrs_wkd_in_perd_rt_f hwr,
277: ben_cvg_amt_calc_mthd_f ccm,
278: ben_bnft_vrbl_rt_f bvr
279: where ccm.'||p_col_name||'= :7
280: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
324: where abr.'||p_col_name||'= :6
325: and abr.acty_base_rt_id = avr.acty_base_rt_id
326: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
327: not exists (select null
328: from ben_hrs_wkd_in_perd_rt_f hwr,
329: ben_acty_base_rt_f abr,
330: ben_acty_vrbl_rt_f avr
331: where abr.'||p_col_name||'= :7
332: and abr.acty_base_rt_id = avr.acty_base_rt_id
373: where apr.'||p_col_name||'= :12
374: and apr.actl_prem_id = apv.actl_prem_id
375: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
376: not exists (select null
377: from ben_hrs_wkd_in_perd_rt_f hwr,
378: ben_actl_prem_f apr,
379: ben_actl_prem_vrbl_rt_f apv
380: where apr.'||p_col_name||'= :13
381: and apr.actl_prem_id = apv.actl_prem_id
423: where ccm.'||p_col_name||'= :18
424: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
425: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
426: not exists (select null
427: from ben_hrs_wkd_in_perd_rt_f hwr,
428: ben_cvg_amt_calc_mthd_f ccm,
429: ben_bnft_vrbl_rt_f bvr
430: where ccm.'||p_col_name||'= :19
431: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
618: where abr.pgm_id = i.pgm_id
619: and abr.acty_base_rt_id = avr.acty_base_rt_id
620: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
621: and not exists (select null
622: from ben_hrs_wkd_in_perd_rt_f hwr,
623: ben_acty_base_rt_f abr,
624: ben_acty_vrbl_rt_f avr
625: where abr.pgm_id = i.pgm_id
626: and abr.acty_base_rt_id = avr.acty_base_rt_id
669: where abr.pl_id = i.pl_id
670: and abr.acty_base_rt_id = avr.acty_base_rt_id
671: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
672: and not exists (select null
673: from ben_hrs_wkd_in_perd_rt_f hwr,
674: ben_acty_base_rt_f abr,
675: ben_acty_vrbl_rt_f avr
676: where abr.pl_id = i.pl_id
677: and abr.acty_base_rt_id = avr.acty_base_rt_id
711: where apr.pl_id = i.pl_id
712: and apr.actl_prem_id = apv.actl_prem_id
713: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
714: and not exists (select null
715: from ben_hrs_wkd_in_perd_rt_f hwr,
716: ben_actl_prem_f apr,
717: ben_actl_prem_vrbl_rt_f apv
718: where apr.pl_id = i.pl_id
719: and apr.actl_prem_id = apv.actl_prem_id
753: where ccm.pl_id = i.pl_id
754: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
755: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
756: and not exists (select null
757: from ben_hrs_wkd_in_perd_rt_f hwr,
758: ben_cvg_amt_calc_mthd_f ccm,
759: ben_bnft_vrbl_rt_f bvr
760: where ccm.pl_id = i.pl_id
761: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
804: where abr.plip_id = i.plip_id
805: and abr.acty_base_rt_id = avr.acty_base_rt_id
806: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
807: and not exists (select null
808: from ben_hrs_wkd_in_perd_rt_f hwr,
809: ben_acty_base_rt_f abr,
810: ben_acty_vrbl_rt_f avr
811: where abr.plip_id = i.plip_id
812: and abr.acty_base_rt_id = avr.acty_base_rt_id
846: where ccm.plip_id = i.plip_id
847: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
848: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
849: and not exists (select null
850: from ben_hrs_wkd_in_perd_rt_f hwr,
851: ben_cvg_amt_calc_mthd_f ccm,
852: ben_bnft_vrbl_rt_f bvr
853: where ccm.plip_id = i.plip_id
854: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
897: where abr.ptip_id = i.ptip_id
898: and abr.acty_base_rt_id = avr.acty_base_rt_id
899: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
900: and not exists (select null
901: from ben_hrs_wkd_in_perd_rt_f hwr,
902: ben_acty_base_rt_f abr,
903: ben_acty_vrbl_rt_f avr
904: where abr.ptip_id = i.ptip_id
905: and abr.acty_base_rt_id = avr.acty_base_rt_id
948: where abr.oipl_id = i.oipl_id
949: and abr.acty_base_rt_id = avr.acty_base_rt_id
950: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
951: and not exists (select null
952: from ben_hrs_wkd_in_perd_rt_f hwr,
953: ben_acty_base_rt_f abr,
954: ben_acty_vrbl_rt_f avr
955: where abr.oipl_id = i.oipl_id
956: and abr.acty_base_rt_id = avr.acty_base_rt_id
990: where apr.oipl_id = i.oipl_id
991: and apr.actl_prem_id = apv.actl_prem_id
992: and apv.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
993: and not exists (select null
994: from ben_hrs_wkd_in_perd_rt_f hwr,
995: ben_actl_prem_f apr,
996: ben_actl_prem_vrbl_rt_f apv
997: where apr.oipl_id = i.oipl_id
998: and apr.actl_prem_id = apv.actl_prem_id
1032: where ccm.oipl_id = i.oipl_id
1033: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1034: and bvr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
1035: and not exists (select null
1036: from ben_hrs_wkd_in_perd_rt_f hwr,
1037: ben_cvg_amt_calc_mthd_f ccm,
1038: ben_bnft_vrbl_rt_f bvr
1039: where ccm.oipl_id = i.oipl_id
1040: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id