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 1040: from ben_enrt_rt er,

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

Line 1049: from ben_enrt_rt er

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

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

8462:
8463:
8464: -- In case of the rate end date codes which depend on rate start date codes
8465: -- LODBEWM and ODBEWM. Presently rt_end_dt is coming out of a cursor using
8466: -- ben_enrt_rt table. If rt_strt_dt_cd is stored in that table instead of
8467: -- rt_strt_dt we get a null . So our plan is to get the rt_end_dt from
8468: -- rt_strt_dt - 1 , if the above codes are used and the result is null
8469: --
8470: if l_rt_end_dt_cd = 'LODBEWM' or l_rt_end_dt_cd = 'ODBEWM'