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_PBN_BUS dependencies on BEN_OIPL_F

Line 234: ,ben_oipl_f oipl

230: SELECT
231: opt.NAME
232: FROM
233: ben_opt_f opt
234: ,ben_oipl_f oipl
235: WHERE
236: oipl.oipl_id=l_bnf_enrt_oipl_id
237: and nvl(l_lf_evt_ocrd_dt,p_effective_date) between oipl.effective_start_date and oipl.effective_end_date
238: and opt.opt_id=oipl.opt_id

Line 998: , ben_oipl_f oipl

994: select distinct drt.rlshp_typ_cd
995: from ben_dsgn_rqmt_rlshp_typ drt
996: , ben_dsgn_rqmt_f drm
997: , ben_opt_f opt
998: , ben_oipl_f oipl
999: , ben_prtt_enrt_rslt_f pen
1000: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1001: and drt.business_group_id = p_business_group_id
1002: and drm.dsgn_typ_cd = 'BNF'

Line 1021: , ben_oipl_f oipl

1017: cursor c_oipl_dsgn_rqmt is
1018: select distinct drt.rlshp_typ_cd
1019: from ben_dsgn_rqmt_rlshp_typ drt
1020: , ben_dsgn_rqmt_f drm
1021: , ben_oipl_f oipl
1022: , ben_prtt_enrt_rslt_f pen
1023: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1024: and drt.business_group_id = p_business_group_id
1025: and drm.dsgn_typ_cd = 'BNF'

Line 1097: from ben_oipl_f oipl

1093: and p_effective_date between pen.effective_start_date and pen.effective_end_date ;
1094: --
1095: cursor c_opt (p_oipl_id number) is
1096: select oipl.opt_id
1097: from ben_oipl_f oipl
1098: where oipl.oipl_id = p_oipl_id
1099: and oipl.business_group_id = p_business_group_id
1100: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
1101:

Line 1378: , ben_oipl_f oipl

1374: (select distinct drt.rlshp_typ_cd
1375: from ben_dsgn_rqmt_rlshp_typ drt
1376: , ben_dsgn_rqmt_f drm
1377: , ben_opt_f opt
1378: , ben_oipl_f oipl
1379: , ben_prtt_enrt_rslt_f pen
1380: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1381: and drt.business_group_id = p_business_group_id
1382: and drm.dsgn_typ_cd = 'BNF'

Line 1412: , ben_oipl_f oipl

1408: and pcr.contact_type in
1409: (select distinct drt.rlshp_typ_cd
1410: from ben_dsgn_rqmt_rlshp_typ drt
1411: , ben_dsgn_rqmt_f drm
1412: , ben_oipl_f oipl
1413: , ben_prtt_enrt_rslt_f pen
1414: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id
1415: and drt.business_group_id = p_business_group_id
1416: and drm.dsgn_typ_cd = 'BNF'

Line 1494: from ben_oipl_f oipl

1490: and p_effective_date between pen.effective_start_date and pen.effective_end_date ;
1491: --
1492: cursor c_opt (p_oipl_id number) is
1493: select oipl.opt_id
1494: from ben_oipl_f oipl
1495: where oipl.oipl_id = p_oipl_id
1496: and oipl.business_group_id = p_business_group_id
1497: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
1498: