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

Line 1163: from ben_prtt_enrt_rslt_f pen,

1159: select pen.bnft_amt
1160: , pln.cmpr_clms_to_cvg_or_bal_cd
1161: ,pen.pgm_id
1162: ,per_in_ler_id
1163: from ben_prtt_enrt_rslt_f pen,
1164: ben_pl_f pln,
1165: ben_popl_yr_perd cpy,
1166: ben_yr_perd yrp
1167: where pln.pl_id = p_pl_id

Line 1180: from ben_prtt_enrt_rslt_f pen_1

1176: and pen.prtt_enrt_rslt_stat_cd is null
1177: AND pen.enrt_cvg_thru_dt >= pen.effective_start_date /* Bug 5607655 : To remove invalid records */
1178: and pen.effective_start_date =
1179: (select max(pen_1.effective_start_date)
1180: from ben_prtt_enrt_rslt_f pen_1
1181: where pen_1.person_id = pen.person_id
1182: and pen_1.pl_id = pen.pl_id
1183: and pen_1.prtt_enrt_rslt_stat_cd is null
1184: and pen_1.enrt_cvg_strt_dt <= yrp.end_date

Line 1534: from ben_prtt_enrt_rslt_f pen, ben_pl_f pln

1530:
1531:
1532: cursor c_per is
1533: select 'x'
1534: from ben_prtt_enrt_rslt_f pen, ben_pl_f pln
1535: where pln.pl_id = p_pl_id
1536: and pln.pl_id = pen.pl_id
1537: and pen.person_id = p_submitter_person_id
1538: and pln.business_group_id = p_business_group_id

Line 1728: from ben_prtt_enrt_rslt_f pen,

1724: ,yrp.start_date
1725: ,yrp.end_date
1726: ,nvl(cpy.acpt_clm_rqsts_thru_dt, pen.enrt_cvg_thru_dt) acpt_clm_rqsts_thru_dt
1727: ,nvl(cpy.PY_CLMS_THRU_DT, yrp.end_date) PY_CLMS_THRU_DT
1728: from ben_prtt_enrt_rslt_f pen,
1729: ben_prtt_enrt_rslt_f pen_l,
1730: ben_popl_yr_perd cpy,
1731: ben_yr_perd yrp
1732: where cpy.pl_id = p_pl_id

Line 1729: ben_prtt_enrt_rslt_f pen_l,

1725: ,yrp.end_date
1726: ,nvl(cpy.acpt_clm_rqsts_thru_dt, pen.enrt_cvg_thru_dt) acpt_clm_rqsts_thru_dt
1727: ,nvl(cpy.PY_CLMS_THRU_DT, yrp.end_date) PY_CLMS_THRU_DT
1728: from ben_prtt_enrt_rslt_f pen,
1729: ben_prtt_enrt_rslt_f pen_l,
1730: ben_popl_yr_perd cpy,
1731: ben_yr_perd yrp
1732: where cpy.pl_id = p_pl_id
1733: and pen.pl_id = cpy.pl_id

Line 1762: from ben_prtt_enrt_rslt_f pen2

1758: --and pen_l.effective_end_date >= yrp.start_date
1759: ---
1760: and pen.prtt_enrt_rslt_id =
1761: (select max(pen2.prtt_enrt_rslt_id)
1762: from ben_prtt_enrt_rslt_f pen2
1763: where pen2.person_id = pen.person_id
1764: and pen2.pl_id = pen.pl_id
1765: and pen2.prtt_enrt_rslt_stat_cd is null
1766: and pen2.SSPNDD_FLAG = 'N'

Line 1773: from ben_prtt_enrt_rslt_f pen_l2

1769: and pen2.effective_end_date = hr_api.g_eot
1770: )
1771: and pen_l.prtt_enrt_rslt_id =
1772: (select min(pen_l2.prtt_enrt_rslt_id)
1773: from ben_prtt_enrt_rslt_f pen_l2
1774: where pen_l2.person_id = pen_l.person_id
1775: and pen_l2.pl_id = pen_l.pl_id
1776: and pen_l2.SSPNDD_FLAG = 'N'
1777: and pen_l2.prtt_enrt_rslt_stat_cd is null

Line 1792: from ben_prtt_enrt_rslt_f pen,

1788: select gds.name,
1789: decode(pgs.GD_SVC_RECD_BASIS_CD, 'DATE', GD_SVC_RECD_BASIS_DT,
1790: decode(pgs.GD_SVC_RECD_BASIS_CD, 'MOINCRDT', add_months(p_exp_incurd_dt,pgs.GD_SVC_RECD_BASIS_MO),
1791: decode(pgs.GD_SVC_RECD_BASIS_CD, 'MOPLYRND', add_months(yrp.end_date,pgs.GD_SVC_RECD_BASIS_MO),yrp.end_date))) earliest_submit_date
1792: from ben_prtt_enrt_rslt_f pen,
1793: ben_popl_yr_perd cpy,
1794: ben_yr_perd yrp,
1795: ben_prtt_clm_gd_or_svc_typ pcg,
1796: ben_pl_gd_or_svc_f pgs,

Line 1833: from ben_prtt_enrt_rslt_f pen,

1829: -- This is to chek the claim happend on the year
1830: -- allow the futur date within the year
1831: cursor c1 is
1832: select nvl(cpy.acpt_clm_rqsts_thru_dt, pen.enrt_cvg_thru_dt)
1833: from ben_prtt_enrt_rslt_f pen,
1834: ben_popl_yr_perd cpy,
1835: ben_yr_perd yrp
1836: where cpy.pl_id = p_pl_id
1837: and pen.pl_id = p_pl_id