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_MANAGE_DEFAULT_ENRT dependencies on BEN_ENRT_RT

Line 1461: From ben_enrt_rt ecr

1457: Cursor c_rt (v_elig_per_elctbl_chc_id number) is
1458: Select ecr.enrt_rt_id
1459: ,nvl(ecr.val,ecr.dflt_val) default_val
1460: ,ecr.ANN_DFLT_VAL
1461: From ben_enrt_rt ecr
1462: Where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
1463: and ecr.business_group_id = p_business_group_id
1464: and ecr.entr_val_at_enrt_flag = 'Y'
1465: -- and ecr.prtt_rt_val_id is null -- ikasire bug 1834655

Line 1470: From ben_enrt_rt ecr

1466: Union
1467: Select ecr.enrt_rt_id
1468: ,nvl(ecr.val,ecr.dflt_val) default_val
1469: ,ecr.ANN_DFLT_VAL
1470: From ben_enrt_rt ecr
1471: ,ben_enrt_bnft enb
1472: Where enb.enrt_bnft_id = ecr.enrt_bnft_id
1473: and ecr.business_group_id = p_business_group_id
1474: and enb.business_group_id = p_business_group_id