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_PREM_F

Line 271: ,ben_prtt_prem_f prm

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
274: ,per_all_people_f per
275: ,per_person_types ptp

Line 375: ,ben_prtt_prem_f prm

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
378: ,per_all_people_f per
379: ,per_person_types ptp

Line 481: ben_prtt_prem_f prm ,

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,
483: per_all_people_f per,
484: per_all_assignments_f asg,
485: per_person_types ptp

Line 561: ,ben_prtt_prem_f prm

557: ,per_all_people_f per
558: ,per_person_types ptp
559: ,per_all_assignments_f asg
560: ,ben_actl_prem_f apr
561: ,ben_prtt_prem_f prm
562: ,ben_prtt_prem_by_mo_f popl
563: where pen.pl_id = p_pl_id
564: and (p_pgm_id is null or pen.pgm_id = p_pgm_id )
565: and pen.prtt_enrt_rslt_stat_cd is null

Line 1294: ,ben_prtt_prem_f prm

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
1297: ,per_all_people_f per
1298: ,per_all_assignments_f asg

Line 1443: ,ben_prtt_prem_f prm

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
1446: and (c_pgm_id is null or pen.pgm_id = c_pgm_id )
1447: and (c_oipl_id is null or pen.oipl_id = c_oipl_id )

Line 1461: from ben_prtt_prem_f prm2

1457: where pil2.per_in_ler_stat_cd in ( 'PROCD' , 'STRTD')
1458: and pil2.lf_evt_ocrd_dt < p_report_start_date
1459: and pil2.person_id = p_person_id )
1460: and prm.effective_start_date = (select max(prm2.effective_start_date)
1461: from ben_prtt_prem_f prm2
1462: where prm2.prtt_prem_id = prm.prtt_prem_id
1463: and prm2.effective_start_date <= p_report_start_date )
1464: and prm.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1465: --and p_report_start_date >= prm.effective_end_date