APPS.BEN_DERIVABLE_RATE dependencies on BEN_BNFT_VRBL_RT_F

Line 257: ben_bnft_vrbl_rt_f bvr

253: and (
254: exists (select null
255: from ben_age_rt_f art,
256: ben_cvg_amt_calc_mthd_f ccm,
257: ben_bnft_vrbl_rt_f bvr
258: where ccm.'||p_col_name||' = :4
259: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
260: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
261: exists (select null

Line 264: ben_bnft_vrbl_rt_f bvr

260: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) or
261: exists (select null
262: from ben_cmbn_age_los_rt_f cmr,
263: ben_cvg_amt_calc_mthd_f ccm,
264: ben_bnft_vrbl_rt_f bvr
265: where ccm.'||p_col_name||'= :5
266: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
267: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
268: exists (select null

Line 271: ben_bnft_vrbl_rt_f bvr

267: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) or
268: exists (select null
269: from ben_comp_lvl_rt_f clr,
270: ben_cvg_amt_calc_mthd_f ccm,
271: ben_bnft_vrbl_rt_f bvr
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

Line 278: ben_bnft_vrbl_rt_f bvr

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

Line 285: ben_bnft_vrbl_rt_f bvr

281: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
282: exists (select null
283: from ben_los_rt_f lsr,
284: ben_cvg_amt_calc_mthd_f ccm,
285: ben_bnft_vrbl_rt_f bvr
286: where ccm.'||p_col_name||'= :8
287: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
288: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
289: exists (select null

Line 292: ben_bnft_vrbl_rt_f bvr

288: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
289: exists (select null
290: from ben_pct_fl_tm_rt_f pfr,
291: ben_cvg_amt_calc_mthd_f ccm,
292: ben_bnft_vrbl_rt_f bvr
293: where ccm.'||p_col_name||'= :9
294: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
295: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id))';
296: --

Line 408: ben_bnft_vrbl_rt_f bvr

404: l_strg := l_strg||' and
405: not exists (select null
406: from ben_age_rt_f art,
407: ben_cvg_amt_calc_mthd_f ccm,
408: ben_bnft_vrbl_rt_f bvr
409: where ccm.'||p_col_name||' = :16
410: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
411: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
412: not exists (select null

Line 415: ben_bnft_vrbl_rt_f bvr

411: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id) and
412: not exists (select null
413: from ben_cmbn_age_los_rt_f cmr,
414: ben_cvg_amt_calc_mthd_f ccm,
415: ben_bnft_vrbl_rt_f bvr
416: where ccm.'||p_col_name||'= :17
417: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
418: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
419: not exists (select null

Line 422: ben_bnft_vrbl_rt_f bvr

418: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id) and
419: not exists (select null
420: from ben_comp_lvl_rt_f clr,
421: ben_cvg_amt_calc_mthd_f ccm,
422: ben_bnft_vrbl_rt_f bvr
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

Line 429: ben_bnft_vrbl_rt_f bvr

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

Line 436: ben_bnft_vrbl_rt_f bvr

432: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
433: not exists (select null
434: from ben_los_rt_f lsr,
435: ben_cvg_amt_calc_mthd_f ccm,
436: ben_bnft_vrbl_rt_f bvr
437: where ccm.'||p_col_name||'= :20
438: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
439: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
440: not exists (select null

Line 443: ben_bnft_vrbl_rt_f bvr

439: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
440: not exists (select null
441: from ben_pct_fl_tm_rt_f pfr,
442: ben_cvg_amt_calc_mthd_f ccm,
443: ben_bnft_vrbl_rt_f bvr
444: where ccm.'||p_col_name||'= :21
445: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
446: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)';
447: --

Line 517: ben_bnft_vrbl_rt_f bvr

513: to_number(null) ptip_id,
514: plip_id,
515: oipl_id
516: from ben_cvg_amt_calc_mthd_f ccm,
517: ben_bnft_vrbl_rt_f bvr
518: where ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
519: and bvr.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
520: ;
521: --

Line 738: ben_bnft_vrbl_rt_f bvr

734: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
735: and not exists (select null
736: from ben_age_rt_f art,
737: ben_cvg_amt_calc_mthd_f ccm,
738: ben_bnft_vrbl_rt_f bvr
739: where ccm.pl_id = i.pl_id
740: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
741: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
742: and not exists (select null

Line 745: ben_bnft_vrbl_rt_f bvr

741: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
742: and not exists (select null
743: from ben_cmbn_age_los_rt_f cmr,
744: ben_cvg_amt_calc_mthd_f ccm,
745: ben_bnft_vrbl_rt_f bvr
746: where ccm.pl_id = i.pl_id
747: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
748: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
749: and not exists (select null

Line 752: ben_bnft_vrbl_rt_f bvr

748: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
749: and not exists (select null
750: from ben_comp_lvl_rt_f clr,
751: ben_cvg_amt_calc_mthd_f ccm,
752: ben_bnft_vrbl_rt_f bvr
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

Line 759: ben_bnft_vrbl_rt_f bvr

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

Line 766: ben_bnft_vrbl_rt_f bvr

762: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
763: and not exists (select null
764: from ben_los_rt_f lsr,
765: ben_cvg_amt_calc_mthd_f ccm,
766: ben_bnft_vrbl_rt_f bvr
767: where ccm.pl_id = i.pl_id
768: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
769: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
770: and not exists (select null

Line 773: ben_bnft_vrbl_rt_f bvr

769: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
770: and not exists (select null
771: from ben_pct_fl_tm_rt_f pfr,
772: ben_cvg_amt_calc_mthd_f ccm,
773: ben_bnft_vrbl_rt_f bvr
774: where ccm.pl_id = i.pl_id
775: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
776: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
777: --

Line 831: ben_bnft_vrbl_rt_f bvr

827: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
828: and not exists (select null
829: from ben_age_rt_f art,
830: ben_cvg_amt_calc_mthd_f ccm,
831: ben_bnft_vrbl_rt_f bvr
832: where ccm.plip_id = i.plip_id
833: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
834: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
835: and not exists (select null

Line 838: ben_bnft_vrbl_rt_f bvr

834: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
835: and not exists (select null
836: from ben_cmbn_age_los_rt_f cmr,
837: ben_cvg_amt_calc_mthd_f ccm,
838: ben_bnft_vrbl_rt_f bvr
839: where ccm.plip_id = i.plip_id
840: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
841: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
842: and not exists (select null

Line 845: ben_bnft_vrbl_rt_f bvr

841: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
842: and not exists (select null
843: from ben_comp_lvl_rt_f clr,
844: ben_cvg_amt_calc_mthd_f ccm,
845: ben_bnft_vrbl_rt_f bvr
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

Line 852: ben_bnft_vrbl_rt_f bvr

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

Line 859: ben_bnft_vrbl_rt_f bvr

855: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
856: and not exists (select null
857: from ben_los_rt_f lsr,
858: ben_cvg_amt_calc_mthd_f ccm,
859: ben_bnft_vrbl_rt_f bvr
860: where ccm.plip_id = i.plip_id
861: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
862: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
863: and not exists (select null

Line 866: ben_bnft_vrbl_rt_f bvr

862: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
863: and not exists (select null
864: from ben_pct_fl_tm_rt_f pfr,
865: ben_cvg_amt_calc_mthd_f ccm,
866: ben_bnft_vrbl_rt_f bvr
867: where ccm.plip_id = i.plip_id
868: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
869: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
870: --

Line 1017: ben_bnft_vrbl_rt_f bvr

1013: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
1014: and not exists (select null
1015: from ben_age_rt_f art,
1016: ben_cvg_amt_calc_mthd_f ccm,
1017: ben_bnft_vrbl_rt_f bvr
1018: where ccm.oipl_id = i.oipl_id
1019: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1020: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
1021: and not exists (select null

Line 1024: ben_bnft_vrbl_rt_f bvr

1020: and bvr.vrbl_rt_prfl_id = art.vrbl_rt_prfl_id)
1021: and not exists (select null
1022: from ben_cmbn_age_los_rt_f cmr,
1023: ben_cvg_amt_calc_mthd_f ccm,
1024: ben_bnft_vrbl_rt_f bvr
1025: where ccm.oipl_id = i.oipl_id
1026: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1027: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1028: and not exists (select null

Line 1031: ben_bnft_vrbl_rt_f bvr

1027: and bvr.vrbl_rt_prfl_id = cmr.vrbl_rt_prfl_id)
1028: and not exists (select null
1029: from ben_comp_lvl_rt_f clr,
1030: ben_cvg_amt_calc_mthd_f ccm,
1031: ben_bnft_vrbl_rt_f bvr
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

Line 1038: ben_bnft_vrbl_rt_f bvr

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

Line 1045: ben_bnft_vrbl_rt_f bvr

1041: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1042: and not exists (select null
1043: from ben_los_rt_f lsr,
1044: ben_cvg_amt_calc_mthd_f ccm,
1045: ben_bnft_vrbl_rt_f bvr
1046: where ccm.oipl_id = i.oipl_id
1047: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1048: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1049: and not exists (select null

Line 1052: ben_bnft_vrbl_rt_f bvr

1048: and bvr.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
1049: and not exists (select null
1050: from ben_pct_fl_tm_rt_f pfr,
1051: ben_cvg_amt_calc_mthd_f ccm,
1052: ben_bnft_vrbl_rt_f bvr
1053: where ccm.oipl_id = i.oipl_id
1054: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id
1055: and bvr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id);
1056: --