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_RECN_REP dependencies on BEN_PRTT_ENRT_RSLT_F

Line 269: from ben_prtt_enrt_rslt_f pen

265: ,ben_recn_rep.get_rate_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_rt_val
266: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_elem_val
267: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_elem_val
268: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_elem_val
269: from ben_prtt_enrt_rslt_f pen
270: ,ben_actl_prem_f acp
271: ,ben_prtt_prem_f prm
272: ,ben_prtt_prem_by_mo_f mpr
273: ,ben_per_in_ler pil

Line 373: from ben_prtt_enrt_rslt_f pen

369: ,ben_recn_rep.get_rate_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_rt_val
370: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_elem_val
371: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_elem_val
372: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_elem_val
373: from ben_prtt_enrt_rslt_f pen
374: ,ben_actl_prem_f acp
375: ,ben_prtt_prem_f prm
376: ,ben_prtt_prem_by_mo_f mpr
377: ,ben_per_in_ler pil

Line 478: from ben_prtt_enrt_rslt_f pen,

474: from ben_prtt_rt_val prv
475: ,pay_element_entry_values_f env
476: where prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
477: and env.element_entry_value_id = prv.element_entry_value_id) lf_elem_val */
478: from ben_prtt_enrt_rslt_f pen,
479: ben_per_in_ler pil,
480: ben_ler_f ler ,
481: ben_prtt_prem_f prm ,
482: ben_prtt_prem_by_mo_f popl,

Line 555: from ben_prtt_enrt_rslt_f pen

551: decode(apr.pl_id, null, ben_batch_utils.get_opt_name(apr.oipl_id, p_business_group_id, p_run_date)) option_name,
552: apr.oipl_id,
553: apr.pl_id ,
554: ben_recn_rep.get_prtt_rate_val(pen.prtt_enrt_rslt_id , p_report_start_date, pen.per_in_ler_id, p_report_end_date) rate-- 3608119
555: from ben_prtt_enrt_rslt_f pen
556: ,ben_per_in_ler pil
557: ,per_all_people_f per
558: ,per_person_types ptp
559: ,per_all_assignments_f asg

Line 1292: from ben_prtt_enrt_rslt_f pen

1288: ) as
1289: --
1290: cursor c_person is
1291: select distinct per.person_id, pil.ler_id
1292: from ben_prtt_enrt_rslt_f pen
1293: ,ben_actl_prem_f acp
1294: ,ben_prtt_prem_f prm
1295: ,ben_prtt_prem_by_mo_f mpr
1296: ,ben_per_in_ler pil

Line 1441: from ben_prtt_enrt_rslt_f pen

1437: --
1438: cursor c_premium(c_pgm_id number, c_oipl_id number) is
1439: select popl.val,
1440: pen.prtt_enrt_rslt_id
1441: from ben_prtt_enrt_rslt_f pen
1442: ,ben_per_in_ler pil
1443: ,ben_prtt_prem_f prm
1444: ,ben_prtt_prem_by_mo_f popl
1445: where pen.pl_id = p_pl_id

Line 1480: from ben_prtt_enrt_rslt_f pen

1476: and add_months(last_day(p_report_start_date),-1) between rt_strt_dt and rt_end_dt;
1477: --
1478: cursor c_mult_enrt is
1479: select count(*)
1480: from ben_prtt_enrt_rslt_f pen
1481: where pen.pl_id = p_pl_id
1482: and pen.person_id = p_person_id
1483: and pen.prtt_enrt_rslt_stat_cd is null
1484: and pen.business_group_id = p_business_group_id