APPS.BEN_DERIVABLE_RATE dependencies on BEN_ACTY_BASE_RT_F

Line 134: ben_acty_base_rt_f abr,

130: drvbl_fctr_apls_rts_flag = :3
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

Line 141: ben_acty_base_rt_f abr,

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
145: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or

Line 148: ben_acty_base_rt_f abr,

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
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

Line 155: ben_acty_base_rt_f abr,

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
159: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or

Line 162: ben_acty_base_rt_f abr,

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
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

Line 169: ben_acty_base_rt_f abr,

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
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))';

Line 296: ben_acty_base_rt_f abr,

292: where '||p_col_name|| '= :2 and
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

Line 303: ben_acty_base_rt_f abr,

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
307: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and

Line 310: ben_acty_base_rt_f abr,

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
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

Line 317: ben_acty_base_rt_f abr,

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
321: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and

Line 324: ben_acty_base_rt_f abr,

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
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

Line 331: ben_acty_base_rt_f abr,

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
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)';

Line 483: from ben_acty_base_rt_f abr,

479: pl_id,
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

Line 590: ben_acty_base_rt_f abr,

586: where pgm_id = i.pgm_id
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)

Line 597: ben_acty_base_rt_f abr,

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
601: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 604: ben_acty_base_rt_f abr,

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
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)

Line 611: ben_acty_base_rt_f abr,

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
615: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 618: ben_acty_base_rt_f abr,

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
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)

Line 625: ben_acty_base_rt_f abr,

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
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);

Line 641: ben_acty_base_rt_f abr,

637: where pl_id = i.pl_id
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)

Line 648: ben_acty_base_rt_f abr,

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
652: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 655: ben_acty_base_rt_f abr,

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
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)

Line 662: ben_acty_base_rt_f abr,

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
666: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 669: ben_acty_base_rt_f abr,

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
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)

Line 676: ben_acty_base_rt_f abr,

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
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)

Line 776: ben_acty_base_rt_f abr,

772: where plip_id = i.plip_id
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)

Line 783: ben_acty_base_rt_f abr,

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
787: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 790: ben_acty_base_rt_f abr,

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
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)

Line 797: ben_acty_base_rt_f abr,

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
801: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 804: ben_acty_base_rt_f abr,

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
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)

Line 811: ben_acty_base_rt_f abr,

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
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)

Line 869: ben_acty_base_rt_f abr,

865: where ptip_id = i.ptip_id
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)

Line 876: ben_acty_base_rt_f abr,

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
880: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 883: ben_acty_base_rt_f abr,

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
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)

Line 890: ben_acty_base_rt_f abr,

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
894: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 897: ben_acty_base_rt_f abr,

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
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)

Line 904: ben_acty_base_rt_f abr,

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
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);

Line 920: ben_acty_base_rt_f abr,

916: where oipl_id = i.oipl_id
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)

Line 927: ben_acty_base_rt_f abr,

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
931: and avr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)

Line 934: ben_acty_base_rt_f abr,

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
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)

Line 941: ben_acty_base_rt_f abr,

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
945: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 948: ben_acty_base_rt_f abr,

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
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)

Line 955: ben_acty_base_rt_f abr,

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
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)