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 1080: ben_acty_base_rt_f abr

1076: abr.rate_periodization_rl, --GEVITY
1077: nvl(eb.mx_wo_ctfn_flag,'N') interim_flag --BUG 5502202
1078: from ben_enrt_rt er,
1079: ben_enrt_bnft eb,
1080: ben_acty_base_rt_f abr
1081: where er.enrt_rt_id=p_enrt_rt_id
1082: and eb.enrt_bnft_id(+)=er.enrt_bnft_id
1083: and er.acty_base_rt_id=abr.acty_base_rt_id
1084: and ( (ben_manage_life_events.fonm = 'Y' and

Line 1169: from ben_acty_base_rt_f abr,

1165: abr2.use_calc_acty_bs_rt_flag,
1166: abr2.acty_base_rt_id,
1167: abr2.rt_mlt_cd,
1168: abr2.entr_ann_val_flag
1169: from ben_acty_base_rt_f abr,
1170: ben_acty_base_rt_f abr2
1171: where abr.acty_base_rt_id = c_acty_base_rt_id
1172: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1173: and abr2.parnt_chld_cd = 'PARNT'

Line 1170: ben_acty_base_rt_f abr2

1166: abr2.acty_base_rt_id,
1167: abr2.rt_mlt_cd,
1168: abr2.entr_ann_val_flag
1169: from ben_acty_base_rt_f abr,
1170: ben_acty_base_rt_f abr2
1171: where abr.acty_base_rt_id = c_acty_base_rt_id
1172: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1173: and abr2.parnt_chld_cd = 'PARNT'
1174: and c_effective_date

Line 1329: from ben_acty_base_rt_f abr

1325: p_effective_date date) is
1326: select abr.ele_entry_val_cd,
1327: abr.element_type_id,
1328: abr.input_value_id
1329: from ben_acty_base_rt_f abr
1330: where abr.acty_base_rt_id = p_acty_base_rt_id
1331: and p_effective_date between abr.effective_start_date
1332: and abr.effective_end_date;
1333: --

Line 1355: ben_acty_base_rt_f abr,

1351: NVL (eb.entr_val_at_enrt_flag, 'N') entr_bnft_val_flag,
1352: eb.cvg_mlt_cd
1353: FROM ben_enrt_rt er,
1354: ben_enrt_bnft eb,
1355: ben_acty_base_rt_f abr,
1356: ben_prtt_enrt_rslt_f pen
1357: WHERE eb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1358: AND pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
1359: AND eb.elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id

Line 1423: ,ben_acty_base_rt_f abr

1419: ,abr.input_value_id
1420: ,pen.person_id
1421: from ben_prtt_enrt_rslt_f pen
1422: ,ben_prtt_rt_val prv
1423: ,ben_acty_base_rt_f abr
1424: where pen.effective_end_date = hr_api.g_eot
1425: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
1426: and pen.prtt_enrt_rslt_stat_cd is null
1427: and pen.person_id = p_person_id

Line 4394: ben_acty_base_rt_f abr,

4390: abr.rate_periodization_rl,
4391: enb.elig_per_elctbl_chc_id,
4392: ert.entr_ann_val_flag
4393: from ben_enrt_rt ert,
4394: ben_acty_base_rt_f abr,
4395: ben_enrt_bnft enb
4396: where enb.enrt_bnft_id = p_enrt_bnft_id
4397: and ert.enrt_bnft_id = enb.enrt_bnft_id
4398: and nvl(abr.PARNT_CHLD_CD,'PARNT') = 'PARNT'