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_ELECTION_INFORMATION dependencies on BEN_ACTY_BASE_RT_F

Line 324: to new column ord_num on ben_acty_base_rt_f

320: 28-Sep-02 ikasire 115.141 Bug 2600087 fixes for deenrolled result
321: 28-Sep-02 ikasire 115.141 Bug 2600087 fixed error making infinit loop
322: 10-Oct-02 shdas 115.143 Changed election_information_w for multirates
323: 11-Oct-02 vsethi 115.144 Rates Sequence no enhancements. Modified to cater
324: to new column ord_num on ben_acty_base_rt_f
325: 15-Oct-02 ikasire 115.145 Bug 2627078 fixes
326: 28-Nov-02 lakrish 115.146 Bug 2499754, set tokens for error messages
327: BEN_91711_ENRT_RSLT_NOT_FND and
328: BEN_91453_CVG_STRT_DT_NOT_FOUN

Line 1226: ben_acty_base_rt_f abr

1222: abr.rate_periodization_rl, --GEVITY
1223: nvl(eb.mx_wo_ctfn_flag,'N') interim_flag --BUG 5502202
1224: from ben_enrt_rt er,
1225: ben_enrt_bnft eb,
1226: ben_acty_base_rt_f abr
1227: where er.enrt_rt_id=p_enrt_rt_id
1228: and eb.enrt_bnft_id(+)=er.enrt_bnft_id
1229: and er.acty_base_rt_id=abr.acty_base_rt_id
1230: and ( (ben_manage_life_events.fonm = 'Y' and

Line 1315: from ben_acty_base_rt_f abr,

1311: abr2.use_calc_acty_bs_rt_flag,
1312: abr2.acty_base_rt_id,
1313: abr2.rt_mlt_cd,
1314: abr2.entr_ann_val_flag
1315: from ben_acty_base_rt_f abr,
1316: ben_acty_base_rt_f abr2
1317: where abr.acty_base_rt_id = c_acty_base_rt_id
1318: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1319: and abr2.parnt_chld_cd = 'PARNT'

Line 1316: ben_acty_base_rt_f abr2

1312: abr2.acty_base_rt_id,
1313: abr2.rt_mlt_cd,
1314: abr2.entr_ann_val_flag
1315: from ben_acty_base_rt_f abr,
1316: ben_acty_base_rt_f abr2
1317: where abr.acty_base_rt_id = c_acty_base_rt_id
1318: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1319: and abr2.parnt_chld_cd = 'PARNT'
1320: and c_effective_date

Line 1538: from ben_acty_base_rt_f abr

1534: p_effective_date date) is
1535: select abr.ele_entry_val_cd,
1536: abr.element_type_id,
1537: abr.input_value_id
1538: from ben_acty_base_rt_f abr
1539: where abr.acty_base_rt_id = p_acty_base_rt_id
1540: and p_effective_date between abr.effective_start_date
1541: and abr.effective_end_date;
1542: --

Line 1564: ben_acty_base_rt_f abr,

1560: NVL (eb.entr_val_at_enrt_flag, 'N') entr_bnft_val_flag,
1561: eb.cvg_mlt_cd
1562: FROM ben_enrt_rt er,
1563: ben_enrt_bnft eb,
1564: ben_acty_base_rt_f abr,
1565: ben_prtt_enrt_rslt_f pen
1566: WHERE eb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1567: AND pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
1568: AND eb.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id

Line 1719: ,ben_acty_base_rt_f abr

1715: ,abr.input_value_id
1716: ,pen.person_id
1717: from ben_prtt_enrt_rslt_f pen
1718: ,ben_prtt_rt_val prv
1719: ,ben_acty_base_rt_f abr
1720: where pen.effective_end_date = hr_api.g_eot
1721: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1722: and pen.prtt_enrt_rslt_stat_cd is null
1723: and pen.person_id = p_person_id

Line 4892: ben_acty_base_rt_f abr,

4888: abr.rate_periodization_rl,
4889: enb.elig_per_elctbl_chc_id,
4890: ert.entr_ann_val_flag
4891: from ben_enrt_rt ert,
4892: ben_acty_base_rt_f abr,
4893: ben_enrt_bnft enb
4894: where enb.enrt_bnft_id = p_enrt_bnft_id
4895: and ert.enrt_bnft_id = enb.enrt_bnft_id
4896: and nvl(abr.PARNT_CHLD_CD,'PARNT') = 'PARNT'