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 145: from ben_age_rt_f art,

141: where '||p_col_name|| '= :2 and
142: drvbl_fctr_apls_rts_flag = :3
143: and (
144: exists (select null
145: from ben_age_rt_f art,
146: ben_acty_base_rt_f abr,
147: ben_acty_vrbl_rt_f avr
148: where abr.'||p_col_name||'= :4
149: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 200: from ben_age_rt_f art,

196: where '||p_col_name|| '= :2 and
197: drvbl_fctr_apls_rts_flag = :3
198: and (
199: exists (select null
200: from ben_age_rt_f art,
201: ben_actl_prem_f apr,
202: ben_actl_prem_vrbl_rt_f apv
203: where apr.'||p_col_name||' = :4
204: and apr.actl_prem_id = apv.actl_prem_id

Line 255: from ben_age_rt_f art,

251: where '||p_col_name|| '= :2 and
252: drvbl_fctr_apls_rts_flag = :3
253: and (
254: exists (select null
255: from ben_age_rt_f art,
256: ben_cvg_amt_calc_mthd_f ccm,
257: ben_bnft_vrbl_rt_f bvr
258: where ccm.'||p_col_name||' = :4
259: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id

Line 307: from ben_age_rt_f art,

303: l_strg := 'update '||p_table_name||' set drvbl_fctr_apls_rts_flag = :1
304: where '||p_col_name|| '= :2 and
305: drvbl_fctr_apls_rts_flag = :3 and
306: not exists (select null
307: from ben_age_rt_f art,
308: ben_acty_base_rt_f abr,
309: ben_acty_vrbl_rt_f avr
310: where abr.'||p_col_name||' = :4
311: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 356: from ben_age_rt_f art,

352: -- Could be a premium rate
353: --
354: l_strg := l_strg||' and
355: not exists (select null
356: from ben_age_rt_f art,
357: ben_actl_prem_f apr,
358: ben_actl_prem_vrbl_rt_f apv
359: where apr.'||p_col_name||' = :10
360: and apr.actl_prem_id = apv.actl_prem_id

Line 406: from ben_age_rt_f art,

402: -- Could be a coverage
403: --
404: l_strg := l_strg||' and
405: not exists (select null
406: from ben_age_rt_f art,
407: ben_cvg_amt_calc_mthd_f ccm,
408: ben_bnft_vrbl_rt_f bvr
409: where ccm.'||p_col_name||' = :16
410: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id

Line 601: from ben_age_rt_f art,

597: set drvbl_fctr_apls_rts_flag = 'N'
598: where pgm_id = i.pgm_id
599: and drvbl_fctr_apls_rts_flag = 'Y'
600: and not exists (select null
601: from ben_age_rt_f art,
602: ben_acty_base_rt_f abr,
603: ben_acty_vrbl_rt_f avr
604: where abr.pgm_id = i.pgm_id
605: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 652: from ben_age_rt_f art,

648: set drvbl_fctr_apls_rts_flag = 'N'
649: where pl_id = i.pl_id
650: and drvbl_fctr_apls_rts_flag = 'Y'
651: and not exists (select null
652: from ben_age_rt_f art,
653: ben_acty_base_rt_f abr,
654: ben_acty_vrbl_rt_f avr
655: where abr.pl_id = i.pl_id
656: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 694: from ben_age_rt_f art,

690: where abr.pl_id = i.pl_id
691: and abr.acty_base_rt_id = avr.acty_base_rt_id
692: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
693: and not exists (select null
694: from ben_age_rt_f art,
695: ben_actl_prem_f apr,
696: ben_actl_prem_vrbl_rt_f apv
697: where apr.pl_id = i.pl_id
698: and apr.actl_prem_id = apv.actl_prem_id

Line 736: from ben_age_rt_f art,

732: where apr.pl_id = i.pl_id
733: and apr.actl_prem_id = apv.actl_prem_id
734: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
735: and not exists (select null
736: from ben_age_rt_f art,
737: ben_cvg_amt_calc_mthd_f ccm,
738: ben_bnft_vrbl_rt_f bvr
739: where ccm.pl_id = i.pl_id
740: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id

Line 787: from ben_age_rt_f art,

783: set drvbl_fctr_apls_rts_flag = 'N'
784: where plip_id = i.plip_id
785: and drvbl_fctr_apls_rts_flag = 'Y'
786: and not exists (select null
787: from ben_age_rt_f art,
788: ben_acty_base_rt_f abr,
789: ben_acty_vrbl_rt_f avr
790: where abr.plip_id = i.plip_id
791: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 829: from ben_age_rt_f art,

825: where abr.plip_id = i.plip_id
826: and abr.acty_base_rt_id = avr.acty_base_rt_id
827: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
828: and not exists (select null
829: from ben_age_rt_f art,
830: ben_cvg_amt_calc_mthd_f ccm,
831: ben_bnft_vrbl_rt_f bvr
832: where ccm.plip_id = i.plip_id
833: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id

Line 880: from ben_age_rt_f art,

876: set drvbl_fctr_apls_rts_flag = 'N'
877: where ptip_id = i.ptip_id
878: and drvbl_fctr_apls_rts_flag = 'Y'
879: and not exists (select null
880: from ben_age_rt_f art,
881: ben_acty_base_rt_f abr,
882: ben_acty_vrbl_rt_f avr
883: where abr.ptip_id = i.ptip_id
884: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 931: from ben_age_rt_f art,

927: set drvbl_fctr_apls_rts_flag = 'N'
928: where oipl_id = i.oipl_id
929: and drvbl_fctr_apls_rts_flag = 'Y'
930: and not exists (select null
931: from ben_age_rt_f art,
932: ben_acty_base_rt_f abr,
933: ben_acty_vrbl_rt_f avr
934: where abr.oipl_id = i.oipl_id
935: and abr.acty_base_rt_id = avr.acty_base_rt_id

Line 973: from ben_age_rt_f art,

969: where abr.oipl_id = i.oipl_id
970: and abr.acty_base_rt_id = avr.acty_base_rt_id
971: and avr.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
972: and not exists (select null
973: from ben_age_rt_f art,
974: ben_actl_prem_f apr,
975: ben_actl_prem_vrbl_rt_f apv
976: where apr.oipl_id = i.oipl_id
977: and apr.actl_prem_id = apv.actl_prem_id

Line 1015: from ben_age_rt_f art,

1011: where apr.oipl_id = i.oipl_id
1012: and apr.actl_prem_id = apv.actl_prem_id
1013: and apv.vrbl_rt_prfl_id = pfr.vrbl_rt_prfl_id)
1014: and not exists (select null
1015: from ben_age_rt_f art,
1016: ben_cvg_amt_calc_mthd_f ccm,
1017: ben_bnft_vrbl_rt_f bvr
1018: where ccm.oipl_id = i.oipl_id
1019: and ccm.cvg_amt_calc_mthd_id = bvr.cvg_amt_calc_mthd_id