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 1407: From ben_enrt_rt ecr

1403: Cursor c_rt (v_elig_per_elctbl_chc_id number) is
1404: Select ecr.enrt_rt_id
1405: ,nvl(ecr.val,ecr.dflt_val) default_val
1406: ,ecr.ANN_DFLT_VAL
1407: From ben_enrt_rt ecr
1408: Where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
1409: and ecr.business_group_id = p_business_group_id
1410: and ecr.entr_val_at_enrt_flag = 'Y'
1411: -- and ecr.prtt_rt_val_id is null -- ikasire bug 1834655

Line 1416: From ben_enrt_rt ecr

1412: Union
1413: Select ecr.enrt_rt_id
1414: ,nvl(ecr.val,ecr.dflt_val) default_val
1415: ,ecr.ANN_DFLT_VAL
1416: From ben_enrt_rt ecr
1417: ,ben_enrt_bnft enb
1418: Where enb.enrt_bnft_id = ecr.enrt_bnft_id
1419: and ecr.business_group_id = p_business_group_id
1420: and enb.business_group_id = p_business_group_id