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_PER_IN_LER

Line 273: ,ben_per_in_ler pil

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
276: ,pay_all_payrolls_f pay
277: ,per_time_periods pds

Line 377: ,ben_per_in_ler pil

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
380: ,pay_all_payrolls_f pay
381: ,per_time_periods pds

Line 479: ben_per_in_ler pil,

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,
483: per_all_people_f per,

Line 500: from ben_per_in_ler pil2

496: where pac.benefit_action_id = p_benefit_action_id) )
497: and pil.per_in_ler_id = pen.per_in_ler_id
498: and pil.per_in_ler_stat_cd not in ( 'VOIDD' , 'BCKDT')
499: and pil.lf_evt_ocrd_dt = ( select max(pil2.LF_EVT_OCRD_DT)
500: from ben_per_in_ler pil2
501: where pil2.per_in_ler_id = pen.per_in_ler_id
502: and pil2.per_in_ler_stat_cd in ( 'STRTD','PROCD')
503: and pil2.lf_evt_ocrd_dt
504: between p_report_start_date and p_report_end_date )

Line 556: ,ben_per_in_ler pil

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
560: ,ben_actl_prem_f apr

Line 1296: ,ben_per_in_ler pil

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
1299: where pen.pl_id = p_pl_id
1300: and (p_pgm_id is null or pen.pgm_id = p_pgm_id)

Line 1442: ,ben_per_in_ler pil

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

Line 1456: from ben_per_in_ler pil2

1452: and pen.sspndd_flag = 'N'
1453: and pil.per_in_ler_id = pen.per_in_ler_id
1454: and pil.per_in_ler_stat_cd in ('PROCD' , 'STRTD')
1455: and pil.lf_evt_ocrd_dt = ( select max(pil2.LF_EVT_OCRD_DT)
1456: from ben_per_in_ler pil2
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)