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_PROVIDER_POOLS dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 3528: ben_bnft_pool_rlovr_rqmt_f prr,

3524: pil.ler_id,
3525: epe.pl_typ_id,
3526: epe.per_in_ler_id
3527: from
3528: ben_bnft_pool_rlovr_rqmt_f prr,
3529: ben_per_in_ler pil,
3530: ben_elig_per_elctbl_chc epe,
3531: ben_enrt_rt ecr,
3532: ben_prtt_rt_val prv,

Line 3604: ben_bnft_pool_rlovr_rqmt_f prr,

3600: pil.ler_id,
3601: epe.pl_typ_id,
3602: epe.per_in_ler_id
3603: from
3604: ben_bnft_pool_rlovr_rqmt_f prr,
3605: ben_per_in_ler pil,
3606: ben_elig_per_elctbl_chc epe,
3607: ben_enrt_bnft enb,
3608: ben_enrt_rt ecr,

Line 4655: from ben_bnft_pool_rlovr_rqmt_f bpr

4651: --
4652: cursor c_get_mx_pct_roll_num is
4653: select bpr.mx_pct_ttl_crs_cn_roll_num
4654: ,bpr.acty_base_rt_id
4655: from ben_bnft_pool_rlovr_rqmt_f bpr
4656: where p_effective_date between
4657: bpr.effective_start_date and
4658: bpr.effective_end_date
4659: and bpr.bnft_prvdr_pool_id=l_ledger_totals.bnft_prvdr_pool_id

Line 5667: ben_bnft_pool_rlovr_rqmt_f prr,

5663: rslt.pgm_id,
5664: rslt.ler_id,
5665: rslt.pl_typ_id
5666: from
5667: ben_bnft_pool_rlovr_rqmt_f prr,
5668: ben_prtt_rt_val prv,
5669: ben_prtt_enrt_rslt_f rslt,
5670: per_all_assignments_f asg,
5671: hr_locations_all loc,