eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DERIVABLE_RATE dependencies on BEN_AGE_RT_F

Line 133: from ben_age_rt_f art,

129: where '||p_col_name|| '= :2 and
130: drvbl_fctr_apls_rts_flag = :3
131: and (
132: exists (select null
133: from ben_age_rt_f art,
134: ben_acty_base_rt_f abr,
135: ben_acty_vrbl_rt_f avr
136: where abr.'||p_col_name||'= :4
137: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 188: from ben_age_rt_f art,

184: where '||p_col_name|| '= :2 and
185: drvbl_fctr_apls_rts_flag = :3
186: and (
187: exists (select null
188: from ben_age_rt_f art,
189: ben_actl_prem_f apr,
190: ben_actl_prem_vrbl_rt_f apv
191: where apr.'||p_col_name||' = :4
192: and apr.actl_prem_id = apv.actl_prem_id

Line 243: from ben_age_rt_f art,

239: where '||p_col_name|| '= :2 and
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

Line 295: from ben_age_rt_f art,

291: l_strg := 'update '||p_table_name||' set drvbl_fctr_apls_rts_flag = :1
292: where '||p_col_name|| '= :2 and
293: drvbl_fctr_apls_rts_flag = :3 and
294: not exists (select null
295: from ben_age_rt_f art,
296: ben_acty_base_rt_f abr,
297: ben_acty_vrbl_rt_f avr
298: where abr.'||p_col_name||' = :4
299: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 344: from ben_age_rt_f art,

340: -- Could be a premium rate
341: --
342: l_strg := l_strg||' and
343: not exists (select null
344: from ben_age_rt_f art,
345: ben_actl_prem_f apr,
346: ben_actl_prem_vrbl_rt_f apv
347: where apr.'||p_col_name||' = :10
348: and apr.actl_prem_id = apv.actl_prem_id

Line 394: from ben_age_rt_f art,

390: -- Could be a coverage
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

Line 589: from ben_age_rt_f art,

585: set drvbl_fctr_apls_rts_flag = 'N'
586: where pgm_id = i.pgm_id
587: and drvbl_fctr_apls_rts_flag = 'Y'
588: and not exists (select null
589: from ben_age_rt_f art,
590: ben_acty_base_rt_f abr,
591: ben_acty_vrbl_rt_f avr
592: where abr.pgm_id = i.pgm_id
593: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 640: from ben_age_rt_f art,

636: set drvbl_fctr_apls_rts_flag = 'N'
637: where pl_id = i.pl_id
638: and drvbl_fctr_apls_rts_flag = 'Y'
639: and not exists (select null
640: from ben_age_rt_f art,
641: ben_acty_base_rt_f abr,
642: ben_acty_vrbl_rt_f avr
643: where abr.pl_id = i.pl_id
644: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 682: from ben_age_rt_f art,

678: where abr.pl_id = i.pl_id
679: and abr.acty_base_rt_id = avr.acty_base_rt_id
680: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
681: and not exists (select null
682: from ben_age_rt_f art,
683: ben_actl_prem_f apr,
684: ben_actl_prem_vrbl_rt_f apv
685: where apr.pl_id = i.pl_id
686: and apr.actl_prem_id = apv.actl_prem_id

Line 724: from ben_age_rt_f art,

720: where apr.pl_id = i.pl_id
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

Line 775: from ben_age_rt_f art,

771: set drvbl_fctr_apls_rts_flag = 'N'
772: where plip_id = i.plip_id
773: and drvbl_fctr_apls_rts_flag = 'Y'
774: and not exists (select null
775: from ben_age_rt_f art,
776: ben_acty_base_rt_f abr,
777: ben_acty_vrbl_rt_f avr
778: where abr.plip_id = i.plip_id
779: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 817: from ben_age_rt_f art,

813: where abr.plip_id = i.plip_id
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

Line 868: from ben_age_rt_f art,

864: set drvbl_fctr_apls_rts_flag = 'N'
865: where ptip_id = i.ptip_id
866: and drvbl_fctr_apls_rts_flag = 'Y'
867: and not exists (select null
868: from ben_age_rt_f art,
869: ben_acty_base_rt_f abr,
870: ben_acty_vrbl_rt_f avr
871: where abr.ptip_id = i.ptip_id
872: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 919: from ben_age_rt_f art,

915: set drvbl_fctr_apls_rts_flag = 'N'
916: where oipl_id = i.oipl_id
917: and drvbl_fctr_apls_rts_flag = 'Y'
918: and not exists (select null
919: from ben_age_rt_f art,
920: ben_acty_base_rt_f abr,
921: ben_acty_vrbl_rt_f avr
922: where abr.oipl_id = i.oipl_id
923: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 961: from ben_age_rt_f art,

957: where abr.oipl_id = i.oipl_id
958: and abr.acty_base_rt_id = avr.acty_base_rt_id
959: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
960: and not exists (select null
961: from ben_age_rt_f art,
962: ben_actl_prem_f apr,
963: ben_actl_prem_vrbl_rt_f apv
964: where apr.oipl_id = i.oipl_id
965: and apr.actl_prem_id = apv.actl_prem_id

Line 1003: from ben_age_rt_f art,

999: where apr.oipl_id = i.oipl_id
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