APPS.BEN_DERIVABLE_RATE dependencies on BEN_LOS_RT_F

Line 173: from ben_los_rt_f lsr,

169: where abr.'||p_col_name||'= :7
170: and abr.acty_base_rt_id = avr.acty_base_rt_id
171: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
172: exists (select null
173: from ben_los_rt_f lsr,
174: ben_acty_base_rt_f abr,
175: ben_acty_vrbl_rt_f avr
176: where abr.'||p_col_name||'= :8
177: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 228: from ben_los_rt_f lsr,

224: where apr.'||p_col_name||'= :7
225: and apr.actl_prem_id = apv.actl_prem_id
226: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) or
227: exists (select null
228: from ben_los_rt_f lsr,
229: ben_actl_prem_f apr,
230: ben_actl_prem_vrbl_rt_f apv
231: where apr.'||p_col_name||'= :8
232: and apr.actl_prem_id = apv.actl_prem_id

Line 283: from ben_los_rt_f lsr,

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

Line 335: from ben_los_rt_f lsr,

331: where abr.'||p_col_name||'= :7
332: and abr.acty_base_rt_id = avr.acty_base_rt_id
333: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
334: not exists (select null
335: from ben_los_rt_f lsr,
336: ben_acty_base_rt_f abr,
337: ben_acty_vrbl_rt_f avr
338: where abr.'||p_col_name||'= :8
339: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 384: from ben_los_rt_f lsr,

380: where apr.'||p_col_name||'= :13
381: and apr.actl_prem_id = apv.actl_prem_id
382: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id) and
383: not exists (select null
384: from ben_los_rt_f lsr,
385: ben_actl_prem_f apr,
386: ben_actl_prem_vrbl_rt_f apv
387: where apr.'||p_col_name||'= :14
388: and apr.actl_prem_id = apv.actl_prem_id

Line 434: from ben_los_rt_f lsr,

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

Line 629: from ben_los_rt_f lsr,

625: where abr.pgm_id = i.pgm_id
626: and abr.acty_base_rt_id = avr.acty_base_rt_id
627: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
628: and not exists (select null
629: from ben_los_rt_f lsr,
630: ben_acty_base_rt_f abr,
631: ben_acty_vrbl_rt_f avr
632: where abr.pgm_id = i.pgm_id
633: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 680: from ben_los_rt_f lsr,

676: where abr.pl_id = i.pl_id
677: and abr.acty_base_rt_id = avr.acty_base_rt_id
678: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
679: and not exists (select null
680: from ben_los_rt_f lsr,
681: ben_acty_base_rt_f abr,
682: ben_acty_vrbl_rt_f avr
683: where abr.pl_id = i.pl_id
684: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 722: from ben_los_rt_f lsr,

718: where apr.pl_id = i.pl_id
719: and apr.actl_prem_id = apv.actl_prem_id
720: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
721: and not exists (select null
722: from ben_los_rt_f lsr,
723: ben_actl_prem_f apr,
724: ben_actl_prem_vrbl_rt_f apv
725: where apr.pl_id = i.pl_id
726: and apr.actl_prem_id = apv.actl_prem_id

Line 764: from ben_los_rt_f lsr,

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

Line 815: from ben_los_rt_f lsr,

811: where abr.plip_id = i.plip_id
812: and abr.acty_base_rt_id = avr.acty_base_rt_id
813: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
814: and not exists (select null
815: from ben_los_rt_f lsr,
816: ben_acty_base_rt_f abr,
817: ben_acty_vrbl_rt_f avr
818: where abr.plip_id = i.plip_id
819: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 857: from ben_los_rt_f lsr,

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

Line 908: from ben_los_rt_f lsr,

904: where abr.ptip_id = i.ptip_id
905: and abr.acty_base_rt_id = avr.acty_base_rt_id
906: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
907: and not exists (select null
908: from ben_los_rt_f lsr,
909: ben_acty_base_rt_f abr,
910: ben_acty_vrbl_rt_f avr
911: where abr.ptip_id = i.ptip_id
912: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 959: from ben_los_rt_f lsr,

955: where abr.oipl_id = i.oipl_id
956: and abr.acty_base_rt_id = avr.acty_base_rt_id
957: and avr.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
958: and not exists (select null
959: from ben_los_rt_f lsr,
960: ben_acty_base_rt_f abr,
961: ben_acty_vrbl_rt_f avr
962: where abr.oipl_id = i.oipl_id
963: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 1001: from ben_los_rt_f lsr,

997: where apr.oipl_id = i.oipl_id
998: and apr.actl_prem_id = apv.actl_prem_id
999: and apv.vrbl_rt_prfl_id = hwr.vrbl_rt_prfl_id)
1000: and not exists (select null
1001: from ben_los_rt_f lsr,
1002: ben_actl_prem_f apr,
1003: ben_actl_prem_vrbl_rt_f apv
1004: where apr.oipl_id = i.oipl_id
1005: and apr.actl_prem_id = apv.actl_prem_id

Line 1043: from ben_los_rt_f lsr,

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