APPS.BEN_DERIVABLE_RATE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 256: ben_cvg_amt_calc_mthd_f ccm,

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

Line 263: ben_cvg_amt_calc_mthd_f ccm,

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

Line 270: ben_cvg_amt_calc_mthd_f ccm,

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

Line 277: ben_cvg_amt_calc_mthd_f ccm,

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

Line 284: ben_cvg_amt_calc_mthd_f ccm,

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

Line 291: ben_cvg_amt_calc_mthd_f ccm,

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

Line 407: ben_cvg_amt_calc_mthd_f ccm,

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

Line 414: ben_cvg_amt_calc_mthd_f ccm,

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

Line 421: ben_cvg_amt_calc_mthd_f ccm,

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

Line 428: ben_cvg_amt_calc_mthd_f ccm,

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
432: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and

Line 435: ben_cvg_amt_calc_mthd_f ccm,

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

Line 442: ben_cvg_amt_calc_mthd_f ccm,

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

Line 516: from ben_cvg_amt_calc_mthd_f ccm,

512: pl_id,
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: ;

Line 737: ben_cvg_amt_calc_mthd_f ccm,

733: and apr.actl_prem_id = apv.actl_prem_id
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)

Line 744: ben_cvg_amt_calc_mthd_f ccm,

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

Line 751: ben_cvg_amt_calc_mthd_f ccm,

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

Line 758: ben_cvg_amt_calc_mthd_f ccm,

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
762: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 765: ben_cvg_amt_calc_mthd_f ccm,

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

Line 772: ben_cvg_amt_calc_mthd_f ccm,

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

Line 830: ben_cvg_amt_calc_mthd_f ccm,

826: and abr.acty_base_rt_id = avr.acty_base_rt_id
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)

Line 837: ben_cvg_amt_calc_mthd_f ccm,

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

Line 844: ben_cvg_amt_calc_mthd_f ccm,

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

Line 851: ben_cvg_amt_calc_mthd_f ccm,

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
855: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 858: ben_cvg_amt_calc_mthd_f ccm,

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

Line 865: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1016: ben_cvg_amt_calc_mthd_f ccm,

1012: and apr.actl_prem_id = apv.actl_prem_id
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)

Line 1023: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1030: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1037: ben_cvg_amt_calc_mthd_f ccm,

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
1041: and bvr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)

Line 1044: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1051: ben_cvg_amt_calc_mthd_f ccm,

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