APPS.BEN_DERIVABLE_RATE dependencies on BEN_LOS_RT_F

Line 161: from ben_los_rt_f lsr,

157: where abr.'||p_col_name||'= :7
158: and abr.acty_base_rt_id = avr.acty_base_rt_id
159: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
160: exists (select null
161: from ben_los_rt_f lsr,
162: ben_acty_base_rt_f abr,
163: ben_acty_vrbl_rt_f avr
164: where abr.'||p_col_name||'= :8
165: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 216: from ben_los_rt_f lsr,

212: where apr.'||p_col_name||'= :7
213: and apr.actl_prem_id = apv.actl_prem_id
214: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
215: exists (select null
216: from ben_los_rt_f lsr,
217: ben_actl_prem_f apr,
218: ben_actl_prem_vrbl_rt_f apv
219: where apr.'||p_col_name||'= :8
220: and apr.actl_prem_id = apv.actl_prem_id

Line 271: from ben_los_rt_f lsr,

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

Line 323: from ben_los_rt_f lsr,

319: where abr.'||p_col_name||'= :7
320: and abr.acty_base_rt_id = avr.acty_base_rt_id
321: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
322: not exists (select null
323: from ben_los_rt_f lsr,
324: ben_acty_base_rt_f abr,
325: ben_acty_vrbl_rt_f avr
326: where abr.'||p_col_name||'= :8
327: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 372: from ben_los_rt_f lsr,

368: where apr.'||p_col_name||'= :13
369: and apr.actl_prem_id = apv.actl_prem_id
370: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
371: not exists (select null
372: from ben_los_rt_f lsr,
373: ben_actl_prem_f apr,
374: ben_actl_prem_vrbl_rt_f apv
375: where apr.'||p_col_name||'= :14
376: and apr.actl_prem_id = apv.actl_prem_id

Line 422: from ben_los_rt_f lsr,

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

Line 617: from ben_los_rt_f lsr,

613: where abr.pgm_id = i.pgm_id
614: and abr.acty_base_rt_id = avr.acty_base_rt_id
615: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
616: and not exists (select null
617: from ben_los_rt_f lsr,
618: ben_acty_base_rt_f abr,
619: ben_acty_vrbl_rt_f avr
620: where abr.pgm_id = i.pgm_id
621: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 668: from ben_los_rt_f lsr,

664: where abr.pl_id = i.pl_id
665: and abr.acty_base_rt_id = avr.acty_base_rt_id
666: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
667: and not exists (select null
668: from ben_los_rt_f lsr,
669: ben_acty_base_rt_f abr,
670: ben_acty_vrbl_rt_f avr
671: where abr.pl_id = i.pl_id
672: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 710: from ben_los_rt_f lsr,

706: where apr.pl_id = i.pl_id
707: and apr.actl_prem_id = apv.actl_prem_id
708: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
709: and not exists (select null
710: from ben_los_rt_f lsr,
711: ben_actl_prem_f apr,
712: ben_actl_prem_vrbl_rt_f apv
713: where apr.pl_id = i.pl_id
714: and apr.actl_prem_id = apv.actl_prem_id

Line 752: from ben_los_rt_f lsr,

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

Line 803: from ben_los_rt_f lsr,

799: where abr.plip_id = i.plip_id
800: and abr.acty_base_rt_id = avr.acty_base_rt_id
801: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
802: and not exists (select null
803: from ben_los_rt_f lsr,
804: ben_acty_base_rt_f abr,
805: ben_acty_vrbl_rt_f avr
806: where abr.plip_id = i.plip_id
807: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 845: from ben_los_rt_f lsr,

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

Line 896: from ben_los_rt_f lsr,

892: where abr.ptip_id = i.ptip_id
893: and abr.acty_base_rt_id = avr.acty_base_rt_id
894: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
895: and not exists (select null
896: from ben_los_rt_f lsr,
897: ben_acty_base_rt_f abr,
898: ben_acty_vrbl_rt_f avr
899: where abr.ptip_id = i.ptip_id
900: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 947: from ben_los_rt_f lsr,

943: where abr.oipl_id = i.oipl_id
944: and abr.acty_base_rt_id = avr.acty_base_rt_id
945: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
946: and not exists (select null
947: from ben_los_rt_f lsr,
948: ben_acty_base_rt_f abr,
949: ben_acty_vrbl_rt_f avr
950: where abr.oipl_id = i.oipl_id
951: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 989: from ben_los_rt_f lsr,

985: where apr.oipl_id = i.oipl_id
986: and apr.actl_prem_id = apv.actl_prem_id
987: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
988: and not exists (select null
989: from ben_los_rt_f lsr,
990: ben_actl_prem_f apr,
991: ben_actl_prem_vrbl_rt_f apv
992: where apr.oipl_id = i.oipl_id
993: and apr.actl_prem_id = apv.actl_prem_id

Line 1031: from ben_los_rt_f lsr,

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