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_PERD

Line 6971: from ben_enrt_perd_for_pl_f epp

6967: epp.rt_strt_dt_cd,
6968: epp.rt_strt_dt_rl,
6969: epp.rt_end_dt_cd,
6970: epp.rt_end_dt_rl
6971: from ben_enrt_perd_for_pl_f epp
6972: where epp.ENRT_PERD_FOR_PL_ID = c_epfp_id
6973: and c_effective_date
6974: between epp.effective_start_date and epp.effective_end_date
6975: union

Line 6990: ben_enrt_perd epd,

6986: epd.rt_strt_dt_rl,
6987: epd.rt_end_dt_cd,
6988: epd.rt_end_dt_rl
6989: from ben_popl_enrt_typ_cycl_f popl,
6990: ben_enrt_perd epd,
6991: ben_per_in_ler pil
6992: where popl.pl_id = c_pl_id
6993: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6994: and pil.per_in_ler_id = c_per_in_ler_id

Line 7016: ben_enrt_perd epd,

7012: epd.rt_strt_dt_rl,
7013: epd.rt_end_dt_cd,
7014: epd.rt_end_dt_rl
7015: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7016: ben_enrt_perd epd,
7017: ben_per_in_ler pil
7018: where popl.pgm_id = c_pgm_id
7019: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
7020: and pil.per_in_ler_id = c_per_in_ler_id

Line 7097: from ben_enrt_perd

7093: rt_strt_dt_cd,
7094: rt_strt_dt_rl,
7095: rt_end_dt_cd,
7096: rt_end_dt_rl
7097: from ben_enrt_perd
7098: where enrt_perd_id=l_enrt_perd_id and
7099: business_group_id =p_business_group_id
7100: union
7101: select '4' order_number,

Line 7139: from ben_enrt_perd_for_pl_f epp

7135: epp.rt_strt_dt_cd,
7136: epp.rt_strt_dt_rl,
7137: epp.rt_end_dt_cd,
7138: epp.rt_end_dt_rl
7139: from ben_enrt_perd_for_pl_f epp
7140: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
7141: and c_effective_date
7142: between epp.effective_start_date and epp.effective_end_date
7143: and ( enrt_cvg_strt_dt_cd is not null

Line 7385: from ben_enrt_perd_for_pl_f epfp

7381: ,c_effective_date in date
7382: )
7383: is
7384: select epfp.ENRT_PERD_FOR_PL_ID
7385: from ben_enrt_perd_for_pl_f epfp
7386: where epfp.lee_rsn_id = c_lee_rsn_id
7387: and epfp.pl_id = c_pl_id
7388: and c_effective_date
7389: between epfp.effective_start_date and epfp.effective_end_date;

Line 7398: from ben_enrt_perd_for_pl_f epfp

7394: ,c_effective_date in date
7395: )
7396: is
7397: select epfp.ENRT_PERD_FOR_PL_ID
7398: from ben_enrt_perd_for_pl_f epfp
7399: where epfp.enrt_perd_id = c_enrt_perd_id
7400: and epfp.pl_id = c_pl_id
7401: and c_effective_date
7402: between epfp.effective_start_date and epfp.effective_end_date;

Line 7418: from ben_enrt_perd_for_pl_f epp

7414: epp.rt_strt_dt_cd,
7415: epp.rt_strt_dt_rl,
7416: epp.rt_end_dt_cd,
7417: epp.rt_end_dt_rl
7418: from ben_enrt_perd_for_pl_f epp
7419: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
7420: and c_effective_date
7421: between epp.effective_start_date and epp.effective_end_date
7422: and ( enrt_cvg_strt_dt_cd is not null