APPS.BEN_DERIVABLE_RATE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 244: ben_cvg_amt_calc_mthd_f ccm,

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

Line 251: ben_cvg_amt_calc_mthd_f ccm,

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

Line 258: ben_cvg_amt_calc_mthd_f ccm,

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

Line 265: ben_cvg_amt_calc_mthd_f ccm,

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

Line 272: ben_cvg_amt_calc_mthd_f ccm,

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

Line 279: ben_cvg_amt_calc_mthd_f ccm,

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

Line 395: ben_cvg_amt_calc_mthd_f ccm,

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

Line 402: ben_cvg_amt_calc_mthd_f ccm,

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

Line 409: ben_cvg_amt_calc_mthd_f ccm,

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

Line 416: ben_cvg_amt_calc_mthd_f ccm,

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

Line 423: ben_cvg_amt_calc_mthd_f ccm,

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

Line 430: ben_cvg_amt_calc_mthd_f ccm,

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

Line 504: from ben_cvg_amt_calc_mthd_f ccm,

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

Line 725: ben_cvg_amt_calc_mthd_f ccm,

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

Line 732: ben_cvg_amt_calc_mthd_f ccm,

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

Line 739: ben_cvg_amt_calc_mthd_f ccm,

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

Line 746: ben_cvg_amt_calc_mthd_f ccm,

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

Line 753: ben_cvg_amt_calc_mthd_f ccm,

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

Line 760: ben_cvg_amt_calc_mthd_f ccm,

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

Line 818: ben_cvg_amt_calc_mthd_f ccm,

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

Line 825: ben_cvg_amt_calc_mthd_f ccm,

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

Line 832: ben_cvg_amt_calc_mthd_f ccm,

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

Line 839: ben_cvg_amt_calc_mthd_f ccm,

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

Line 846: ben_cvg_amt_calc_mthd_f ccm,

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

Line 853: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1004: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1011: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1018: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1025: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1032: ben_cvg_amt_calc_mthd_f ccm,

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

Line 1039: ben_cvg_amt_calc_mthd_f ccm,

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