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

Line 1038: from ben_enrt_rt er,

1034: -- Added to fix code ODBEWM
1035: --
1036: cursor c_enrt_rt_val_dt is
1037: select er.rt_strt_dt
1038: from ben_enrt_rt er,
1039: ben_enrt_bnft eb
1040: where eb.elig_per_elctbl_chc_id =p_elig_per_elctbl_chc_id
1041: and er.elig_per_elctbl_chc_id is null
1042: and eb.enrt_bnft_id=er.enrt_bnft_id

Line 1047: from ben_enrt_rt er

1043: --
1044: union
1045: --
1046: select er.rt_strt_dt
1047: from ben_enrt_rt er
1048: where er.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id ;
1049:
1050: cursor c_elig_dpnt_dts is
1051: select ecd.cvg_strt_dt,

Line 8265: -- ben_enrt_rt table. If rt_strt_dt_cd is stored in that table instead of

8261:
8262:
8263: -- In case of the rate end date codes which depend on rate start date codes
8264: -- LODBEWM and ODBEWM. Presently rt_end_dt is coming out of a cursor using
8265: -- ben_enrt_rt table. If rt_strt_dt_cd is stored in that table instead of
8266: -- rt_strt_dt we get a null . So our plan is to get the rt_end_dt from
8267: -- rt_strt_dt - 1 , if the above codes are used and the result is null
8268: --
8269: if l_rt_end_dt_cd = 'LODBEWM' or l_rt_end_dt_cd = 'ODBEWM'