APPS.BEN_DERIVABLE_RATE dependencies on BEN_PCT_FL_TM_RT_F

Line 168: from ben_pct_fl_tm_rt_f pfr,

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

Line 223: from ben_pct_fl_tm_rt_f pfr,

219: where apr.'||p_col_name||'= :8
220: and apr.actl_prem_id = apv.actl_prem_id
221: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) or
222: exists (select null
223: from ben_pct_fl_tm_rt_f pfr,
224: ben_actl_prem_f apr,
225: ben_actl_prem_vrbl_rt_f apv
226: where apr.'||p_col_name||'= :9
227: and apr.actl_prem_id = apv.actl_prem_id

Line 278: from ben_pct_fl_tm_rt_f pfr,

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

Line 330: from ben_pct_fl_tm_rt_f pfr,

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

Line 379: from ben_pct_fl_tm_rt_f pfr,

375: where apr.'||p_col_name||'= :14
376: and apr.actl_prem_id = apv.actl_prem_id
377: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id) and
378: not exists (select null
379: from ben_pct_fl_tm_rt_f pfr,
380: ben_actl_prem_f apr,
381: ben_actl_prem_vrbl_rt_f apv
382: where apr.'||p_col_name||'= :15
383: and apr.actl_prem_id = apv.actl_prem_id

Line 429: from ben_pct_fl_tm_rt_f pfr,

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

Line 624: from ben_pct_fl_tm_rt_f pfr,

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

Line 675: from ben_pct_fl_tm_rt_f pfr,

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

Line 717: from ben_pct_fl_tm_rt_f pfr,

713: where apr.pl_id = i.pl_id
714: and apr.actl_prem_id = apv.actl_prem_id
715: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
716: and not exists (select null
717: from ben_pct_fl_tm_rt_f pfr,
718: ben_actl_prem_f apr,
719: ben_actl_prem_vrbl_rt_f apv
720: where apr.pl_id = i.pl_id
721: and apr.actl_prem_id = apv.actl_prem_id

Line 759: from ben_pct_fl_tm_rt_f pfr,

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

Line 810: from ben_pct_fl_tm_rt_f pfr,

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

Line 852: from ben_pct_fl_tm_rt_f pfr,

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

Line 903: from ben_pct_fl_tm_rt_f pfr,

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

Line 954: from ben_pct_fl_tm_rt_f pfr,

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

Line 996: from ben_pct_fl_tm_rt_f pfr,

992: where apr.oipl_id = i.oipl_id
993: and apr.actl_prem_id = apv.actl_prem_id
994: and apv.vrbl_rt_prfl_id = lsr.vrbl_rt_prfl_id)
995: and not exists (select null
996: from ben_pct_fl_tm_rt_f pfr,
997: ben_actl_prem_f apr,
998: ben_actl_prem_vrbl_rt_f apv
999: where apr.oipl_id = i.oipl_id
1000: and apr.actl_prem_id = apv.actl_prem_id

Line 1038: from ben_pct_fl_tm_rt_f pfr,

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