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_DSGN_RQMT_RLSHP_TYP

Line 995: from ben_dsgn_rqmt_rlshp_typ drt

991: --
992: --
993: cursor c_opt_dsgn_rqmt is
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

Line 1019: from ben_dsgn_rqmt_rlshp_typ drt

1015: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id ;
1016: --
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

Line 1039: from ben_dsgn_rqmt_rlshp_typ drt

1035: and pen.prtt_enrt_rslt_stat_cd is null;
1036: --
1037: cursor c_pl_dsgn_rqmt is
1038: select distinct drt.rlshp_typ_cd
1039: from ben_dsgn_rqmt_rlshp_typ drt
1040: , ben_dsgn_rqmt_f drm
1041: , ben_pl_f pln
1042: , ben_prtt_enrt_rslt_f pen
1043: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id

Line 1375: from ben_dsgn_rqmt_rlshp_typ drt

1371: and pcr.contact_person_id = p_bnf_person_id
1372: and p_effective_date between nvl(pcr.date_start,p_effective_date) and nvl(pcr.date_end,p_effective_date)
1373: and pcr.contact_type in
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

Line 1410: from ben_dsgn_rqmt_rlshp_typ drt

1406: and pcr.contact_person_id = p_bnf_person_id
1407: and p_effective_date between nvl(pcr.date_start,p_effective_date) and nvl(pcr.date_end,p_effective_date)
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

Line 1441: from ben_dsgn_rqmt_rlshp_typ drt

1437: and pcr.contact_person_id = p_bnf_person_id
1438: and p_effective_date between nvl(pcr.date_start,p_effective_date) and nvl(pcr.date_end,p_effective_date)
1439: and pcr.contact_type in
1440: (select distinct drt.rlshp_typ_cd
1441: from ben_dsgn_rqmt_rlshp_typ drt
1442: , ben_dsgn_rqmt_f drm
1443: , ben_pl_f pln
1444: , ben_prtt_enrt_rslt_f pen
1445: where drt.dsgn_rqmt_id = drm.dsgn_rqmt_id