APPS.BEN_DERIVABLE_RATE dependencies on BEN_BNFT_VRBL_RT_F

Line 245: ben_bnft_vrbl_rt_f bvr

241: and (
242: exists (select null
243: from ben_age_rt_f art,
244: ben_cvg_amt_calc_mthd_f ccm,
245: ben_bnft_vrbl_rt_f bvr
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

Line 252: ben_bnft_vrbl_rt_f bvr

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
255: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
256: exists (select null

Line 259: ben_bnft_vrbl_rt_f bvr

255: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
256: exists (select null
257: from ben_comp_lvl_rt_f clr,
258: ben_cvg_amt_calc_mthd_f ccm,
259: ben_bnft_vrbl_rt_f bvr
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

Line 266: ben_bnft_vrbl_rt_f bvr

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
269: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
270: exists (select null

Line 273: ben_bnft_vrbl_rt_f bvr

269: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
270: exists (select null
271: from ben_los_rt_f lsr,
272: ben_cvg_amt_calc_mthd_f ccm,
273: ben_bnft_vrbl_rt_f bvr
274: where ccm.'||p_col_name||'= :8
275: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
276: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
277: exists (select null

Line 280: ben_bnft_vrbl_rt_f bvr

276: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
277: exists (select null
278: from ben_pct_fl_tm_rt_f pfr,
279: ben_cvg_amt_calc_mthd_f ccm,
280: ben_bnft_vrbl_rt_f bvr
281: where ccm.'||p_col_name||'= :9
282: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
283: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id))';
284: --

Line 396: ben_bnft_vrbl_rt_f bvr

392: l_strg := l_strg||' and
393: not exists (select null
394: from ben_age_rt_f art,
395: ben_cvg_amt_calc_mthd_f ccm,
396: ben_bnft_vrbl_rt_f bvr
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

Line 403: ben_bnft_vrbl_rt_f bvr

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
406: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
407: not exists (select null

Line 410: ben_bnft_vrbl_rt_f bvr

406: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
407: not exists (select null
408: from ben_comp_lvl_rt_f clr,
409: ben_cvg_amt_calc_mthd_f ccm,
410: ben_bnft_vrbl_rt_f bvr
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

Line 417: ben_bnft_vrbl_rt_f bvr

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
420: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
421: not exists (select null

Line 424: ben_bnft_vrbl_rt_f bvr

420: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
421: not exists (select null
422: from ben_los_rt_f lsr,
423: ben_cvg_amt_calc_mthd_f ccm,
424: ben_bnft_vrbl_rt_f bvr
425: where ccm.'||p_col_name||'= :20
426: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
427: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
428: not exists (select null

Line 431: ben_bnft_vrbl_rt_f bvr

427: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
428: not exists (select null
429: from ben_pct_fl_tm_rt_f pfr,
430: ben_cvg_amt_calc_mthd_f ccm,
431: ben_bnft_vrbl_rt_f bvr
432: where ccm.'||p_col_name||'= :21
433: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
434: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)';
435: --

Line 505: ben_bnft_vrbl_rt_f bvr

501: to_number(null) ptip_id,
502: plip_id,
503: oipl_id
504: from ben_cvg_amt_calc_mthd_f ccm,
505: ben_bnft_vrbl_rt_f bvr
506: where ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
507: and bvr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
508: ;
509: --

Line 726: ben_bnft_vrbl_rt_f bvr

722: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
723: and not exists (select null
724: from ben_age_rt_f art,
725: ben_cvg_amt_calc_mthd_f ccm,
726: ben_bnft_vrbl_rt_f bvr
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

Line 733: ben_bnft_vrbl_rt_f bvr

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
736: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
737: and not exists (select null

Line 740: ben_bnft_vrbl_rt_f bvr

736: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
737: and not exists (select null
738: from ben_comp_lvl_rt_f clr,
739: ben_cvg_amt_calc_mthd_f ccm,
740: ben_bnft_vrbl_rt_f bvr
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

Line 747: ben_bnft_vrbl_rt_f bvr

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
750: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
751: and not exists (select null

Line 754: ben_bnft_vrbl_rt_f bvr

750: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
751: and not exists (select null
752: from ben_los_rt_f lsr,
753: ben_cvg_amt_calc_mthd_f ccm,
754: ben_bnft_vrbl_rt_f bvr
755: where ccm.pl_id = i.pl_id
756: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
757: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
758: and not exists (select null

Line 761: ben_bnft_vrbl_rt_f bvr

757: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
758: and not exists (select null
759: from ben_pct_fl_tm_rt_f pfr,
760: ben_cvg_amt_calc_mthd_f ccm,
761: ben_bnft_vrbl_rt_f bvr
762: where ccm.pl_id = i.pl_id
763: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
764: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
765: --

Line 819: ben_bnft_vrbl_rt_f bvr

815: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
816: and not exists (select null
817: from ben_age_rt_f art,
818: ben_cvg_amt_calc_mthd_f ccm,
819: ben_bnft_vrbl_rt_f bvr
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

Line 826: ben_bnft_vrbl_rt_f bvr

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
829: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
830: and not exists (select null

Line 833: ben_bnft_vrbl_rt_f bvr

829: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
830: and not exists (select null
831: from ben_comp_lvl_rt_f clr,
832: ben_cvg_amt_calc_mthd_f ccm,
833: ben_bnft_vrbl_rt_f bvr
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

Line 840: ben_bnft_vrbl_rt_f bvr

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
843: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
844: and not exists (select null

Line 847: ben_bnft_vrbl_rt_f bvr

843: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
844: and not exists (select null
845: from ben_los_rt_f lsr,
846: ben_cvg_amt_calc_mthd_f ccm,
847: ben_bnft_vrbl_rt_f bvr
848: where ccm.plip_id = i.plip_id
849: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
850: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
851: and not exists (select null

Line 854: ben_bnft_vrbl_rt_f bvr

850: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
851: and not exists (select null
852: from ben_pct_fl_tm_rt_f pfr,
853: ben_cvg_amt_calc_mthd_f ccm,
854: ben_bnft_vrbl_rt_f bvr
855: where ccm.plip_id = i.plip_id
856: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
857: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
858: --

Line 1005: ben_bnft_vrbl_rt_f bvr

1001: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
1002: and not exists (select null
1003: from ben_age_rt_f art,
1004: ben_cvg_amt_calc_mthd_f ccm,
1005: ben_bnft_vrbl_rt_f bvr
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

Line 1012: ben_bnft_vrbl_rt_f bvr

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
1015: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1016: and not exists (select null

Line 1019: ben_bnft_vrbl_rt_f bvr

1015: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1016: and not exists (select null
1017: from ben_comp_lvl_rt_f clr,
1018: ben_cvg_amt_calc_mthd_f ccm,
1019: ben_bnft_vrbl_rt_f bvr
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

Line 1026: ben_bnft_vrbl_rt_f bvr

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
1029: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1030: and not exists (select null

Line 1033: ben_bnft_vrbl_rt_f bvr

1029: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1030: and not exists (select null
1031: from ben_los_rt_f lsr,
1032: ben_cvg_amt_calc_mthd_f ccm,
1033: ben_bnft_vrbl_rt_f bvr
1034: where ccm.oipl_id = i.oipl_id
1035: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1036: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1037: and not exists (select null

Line 1040: ben_bnft_vrbl_rt_f bvr

1036: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1037: and not exists (select null
1038: from ben_pct_fl_tm_rt_f pfr,
1039: ben_cvg_amt_calc_mthd_f ccm,
1040: ben_bnft_vrbl_rt_f bvr
1041: where ccm.oipl_id = i.oipl_id
1042: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1043: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
1044: --