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_PDP_BUS dependencies on BEN_DSGN_RQMT_F

Line 561: from ben_dsgn_rqmt_f

557: cursor total_rqmt_c is
558: select mx_dpnts_alwd_num
559: ,no_mx_num_dfnd_flag
560: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
561: from ben_dsgn_rqmt_f
562: where
563: ((nvl(pl_id, hr_api.g_number) = l_pl_id)
564: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
565: or (nvl(opt_id, hr_api.g_number) = l_opt_id))

Line 579: from ben_dsgn_rqmt_f r

575: -- any designation requirements for this comp object?
576: --
577: cursor any_rqmt_c is
578: select 's'
579: from ben_dsgn_rqmt_f r
580: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
581: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
582: or (nvl(opt_id, hr_api.g_number) = l_opt_id))
583: and r.dsgn_typ_cd = 'DPNT'

Line 597: from ben_dsgn_rqmt_f r,

593: select r.mx_dpnts_alwd_num
594: ,r.no_mx_num_dfnd_flag
595: ,r.dsgn_rqmt_id
596: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
597: from ben_dsgn_rqmt_f r,
598: ben_dsgn_rqmt_rlshp_typ dr
599: where ((nvl(pl_id, hr_api.g_number) = l_pl_id)
600: or (nvl(oipl_id, hr_api.g_number) = l_oipl_id)
601: or (nvl(opt_id, hr_api.g_number) = l_opt_id))