APPS.BEN_DERIVABLE_RATE dependencies on BEN_ACTY_VRBL_RT_F

Line 135: ben_acty_vrbl_rt_f avr

131: and (
132: exists (select null
133: from ben_age_rt_f art,
134: ben_acty_base_rt_f abr,
135: ben_acty_vrbl_rt_f avr
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

Line 142: ben_acty_vrbl_rt_f avr

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
145: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
146: exists (select null

Line 149: ben_acty_vrbl_rt_f avr

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
152: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) or
153: exists (select null

Line 156: ben_acty_vrbl_rt_f avr

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
159: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
160: exists (select null

Line 163: ben_acty_vrbl_rt_f avr

159: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
160: exists (select null
161: from ben_los_rt_f lsr,
162: ben_acty_base_rt_f abr,
163: ben_acty_vrbl_rt_f avr
164: where abr.'||p_col_name||'= :8
165: and abr.acty_base_rt_id = avr.acty_base_rt_id
166: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
167: exists (select null

Line 170: ben_acty_vrbl_rt_f avr

166: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
167: exists (select null
168: from ben_pct_fl_tm_rt_f pfr,
169: ben_acty_base_rt_f abr,
170: ben_acty_vrbl_rt_f avr
171: where abr.'||p_col_name||'= :9
172: and abr.acty_base_rt_id = avr.acty_base_rt_id
173: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id))';
174: --

Line 297: ben_acty_vrbl_rt_f avr

293: drvbl_fctr_apls_rts_flag = :3 and
294: not exists (select null
295: from ben_age_rt_f art,
296: ben_acty_base_rt_f abr,
297: ben_acty_vrbl_rt_f avr
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

Line 304: ben_acty_vrbl_rt_f avr

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
307: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
308: not exists (select null

Line 311: ben_acty_vrbl_rt_f avr

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
314: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id) and
315: not exists (select null

Line 318: ben_acty_vrbl_rt_f avr

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
321: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
322: not exists (select null

Line 325: ben_acty_vrbl_rt_f avr

321: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
322: not exists (select null
323: from ben_los_rt_f lsr,
324: ben_acty_base_rt_f abr,
325: ben_acty_vrbl_rt_f avr
326: where abr.'||p_col_name||'= :8
327: and abr.acty_base_rt_id = avr.acty_base_rt_id
328: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
329: not exists (select null

Line 332: ben_acty_vrbl_rt_f avr

328: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
329: not exists (select null
330: from ben_pct_fl_tm_rt_f pfr,
331: ben_acty_base_rt_f abr,
332: ben_acty_vrbl_rt_f avr
333: where abr.'||p_col_name||'= :9
334: and abr.acty_base_rt_id = avr.acty_base_rt_id
335: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)';
336: --

Line 484: ben_acty_vrbl_rt_f avr

480: ptip_id,
481: plip_id,
482: oipl_id
483: from ben_acty_base_rt_f abr,
484: ben_acty_vrbl_rt_f avr
485: where avr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
486: and avr.acty_base_rt_id = abr.acty_base_rt_id
487: -- RCHASE bug 1568561 - added union
488: union

Line 591: ben_acty_vrbl_rt_f avr

587: and drvbl_fctr_apls_rts_flag = 'Y'
588: and not exists (select null
589: from ben_age_rt_f art,
590: ben_acty_base_rt_f abr,
591: ben_acty_vrbl_rt_f avr
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

Line 598: ben_acty_vrbl_rt_f avr

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
601: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
602: and not exists (select null

Line 605: ben_acty_vrbl_rt_f avr

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
608: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
609: and not exists (select null

Line 612: ben_acty_vrbl_rt_f avr

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
615: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
616: and not exists (select null

Line 619: ben_acty_vrbl_rt_f avr

615: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
616: and not exists (select null
617: from ben_los_rt_f lsr,
618: ben_acty_base_rt_f abr,
619: ben_acty_vrbl_rt_f avr
620: where abr.pgm_id = i.pgm_id
621: and abr.acty_base_rt_id = avr.acty_base_rt_id
622: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
623: and not exists (select null

Line 626: ben_acty_vrbl_rt_f avr

622: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
623: and not exists (select null
624: from ben_pct_fl_tm_rt_f pfr,
625: ben_acty_base_rt_f abr,
626: ben_acty_vrbl_rt_f avr
627: where abr.pgm_id = i.pgm_id
628: and abr.acty_base_rt_id = avr.acty_base_rt_id
629: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
630: --

Line 642: ben_acty_vrbl_rt_f avr

638: and drvbl_fctr_apls_rts_flag = 'Y'
639: and not exists (select null
640: from ben_age_rt_f art,
641: ben_acty_base_rt_f abr,
642: ben_acty_vrbl_rt_f avr
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

Line 649: ben_acty_vrbl_rt_f avr

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
652: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
653: and not exists (select null

Line 656: ben_acty_vrbl_rt_f avr

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
659: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
660: and not exists (select null

Line 663: ben_acty_vrbl_rt_f avr

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
666: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
667: and not exists (select null

Line 670: ben_acty_vrbl_rt_f avr

666: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
667: and not exists (select null
668: from ben_los_rt_f lsr,
669: ben_acty_base_rt_f abr,
670: ben_acty_vrbl_rt_f avr
671: where abr.pl_id = i.pl_id
672: and abr.acty_base_rt_id = avr.acty_base_rt_id
673: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
674: and not exists (select null

Line 677: ben_acty_vrbl_rt_f avr

673: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
674: and not exists (select null
675: from ben_pct_fl_tm_rt_f pfr,
676: ben_acty_base_rt_f abr,
677: ben_acty_vrbl_rt_f avr
678: where abr.pl_id = i.pl_id
679: and abr.acty_base_rt_id = avr.acty_base_rt_id
680: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
681: and not exists (select null

Line 777: ben_acty_vrbl_rt_f avr

773: and drvbl_fctr_apls_rts_flag = 'Y'
774: and not exists (select null
775: from ben_age_rt_f art,
776: ben_acty_base_rt_f abr,
777: ben_acty_vrbl_rt_f avr
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

Line 784: ben_acty_vrbl_rt_f avr

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
787: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
788: and not exists (select null

Line 791: ben_acty_vrbl_rt_f avr

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
794: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
795: and not exists (select null

Line 798: ben_acty_vrbl_rt_f avr

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
801: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
802: and not exists (select null

Line 805: ben_acty_vrbl_rt_f avr

801: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
802: and not exists (select null
803: from ben_los_rt_f lsr,
804: ben_acty_base_rt_f abr,
805: ben_acty_vrbl_rt_f avr
806: where abr.plip_id = i.plip_id
807: and abr.acty_base_rt_id = avr.acty_base_rt_id
808: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
809: and not exists (select null

Line 812: ben_acty_vrbl_rt_f avr

808: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
809: and not exists (select null
810: from ben_pct_fl_tm_rt_f pfr,
811: ben_acty_base_rt_f abr,
812: ben_acty_vrbl_rt_f avr
813: where abr.plip_id = i.plip_id
814: and abr.acty_base_rt_id = avr.acty_base_rt_id
815: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
816: and not exists (select null

Line 870: ben_acty_vrbl_rt_f avr

866: and drvbl_fctr_apls_rts_flag = 'Y'
867: and not exists (select null
868: from ben_age_rt_f art,
869: ben_acty_base_rt_f abr,
870: ben_acty_vrbl_rt_f avr
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

Line 877: ben_acty_vrbl_rt_f avr

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
880: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
881: and not exists (select null

Line 884: ben_acty_vrbl_rt_f avr

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
887: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
888: and not exists (select null

Line 891: ben_acty_vrbl_rt_f avr

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
894: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
895: and not exists (select null

Line 898: ben_acty_vrbl_rt_f avr

894: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
895: and not exists (select null
896: from ben_los_rt_f lsr,
897: ben_acty_base_rt_f abr,
898: ben_acty_vrbl_rt_f avr
899: where abr.ptip_id = i.ptip_id
900: and abr.acty_base_rt_id = avr.acty_base_rt_id
901: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
902: and not exists (select null

Line 905: ben_acty_vrbl_rt_f avr

901: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
902: and not exists (select null
903: from ben_pct_fl_tm_rt_f pfr,
904: ben_acty_base_rt_f abr,
905: ben_acty_vrbl_rt_f avr
906: where abr.ptip_id = i.ptip_id
907: and abr.acty_base_rt_id = avr.acty_base_rt_id
908: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
909: --

Line 921: ben_acty_vrbl_rt_f avr

917: and drvbl_fctr_apls_rts_flag = 'Y'
918: and not exists (select null
919: from ben_age_rt_f art,
920: ben_acty_base_rt_f abr,
921: ben_acty_vrbl_rt_f avr
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

Line 928: ben_acty_vrbl_rt_f avr

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
931: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
932: and not exists (select null

Line 935: ben_acty_vrbl_rt_f avr

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
938: and avr.vrbl_rt_prfl_id = clr.vrbl_rt_prfl_id)
939: and not exists (select null

Line 942: ben_acty_vrbl_rt_f avr

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
945: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
946: and not exists (select null

Line 949: ben_acty_vrbl_rt_f avr

945: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
946: and not exists (select null
947: from ben_los_rt_f lsr,
948: ben_acty_base_rt_f abr,
949: ben_acty_vrbl_rt_f avr
950: where abr.oipl_id = i.oipl_id
951: and abr.acty_base_rt_id = avr.acty_base_rt_id
952: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
953: and not exists (select null

Line 956: ben_acty_vrbl_rt_f avr

952: and avr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
953: and not exists (select null
954: from ben_pct_fl_tm_rt_f pfr,
955: ben_acty_base_rt_f abr,
956: ben_acty_vrbl_rt_f avr
957: where abr.oipl_id = i.oipl_id
958: and abr.acty_base_rt_id = avr.acty_base_rt_id
959: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
960: and not exists (select null