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

Line 42: 110.8 15 Jun 98 J Schneider ben_dsgn_rqmt_f now uses oipl_id

38: enrt_actn_f so all action items will
39: suspend enrt if new or cmpltd_dt is NULL
40: 110.7 13 Jun 98 J Schneider l_g_suspend,l_suspend_flag rechecked for
41: problems
42: 110.8 15 Jun 98 J Schneider ben_dsgn_rqmt_f now uses oipl_id
43: 110.9 15 Jun 98 J Schneider redo oipl pl dsgn_rqmt
44: 110.10 16 Jun 98 J Schneider dsgn_rqmt needs more work for DDADDNL
45: 110.11 17 Jun 98 J Schneider recheck for DDADDNL if no dependents found
46: 110.12 18 Jun 98 J Schneider return suspend flag at all times

Line 4684: from ben_dsgn_rqmt_f drq,

4680: select sum(tot_mn_dpnts_rqd_num) tot_mn_dpnts_rqd_num,
4681: sum(tot_mx_dpnts_alwd_num) tot_mx_dpnts_alwd_num
4682: from (select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4683: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4684: from ben_dsgn_rqmt_f drq,
4685: ben_oipl_f cop,
4686: ben_prtt_enrt_rslt_f pen
4687: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4688: -- and drq.oipl_id = pen.oipl_id -- 3730053: OPT level DSGN_RQMTS override OIPL level

Line 4693: from ben_dsgn_rqmt_f drq2

4689: and pen.oipl_id = cop.oipl_id
4690: and ( (drq.oipl_id = pen.oipl_id
4691: and not exists
4692: (select null
4693: from ben_dsgn_rqmt_f drq2
4694: where drq2.opt_id = cop.opt_id
4695: and p_effective_date between drq2.effective_start_date
4696: and drq2.effective_end_date))
4697: or cop.opt_id = drq.opt_id)

Line 4713: from ben_dsgn_rqmt_f drq,

4709: and drq.effective_end_date
4710: UNION -- 3730053: Added this to check PL-level designation requirements are specified at PLAN-LEVEL.
4711: select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4712: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4713: from ben_dsgn_rqmt_f drq,
4714: ben_prtt_enrt_rslt_f pen
4715: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4716: and drq.pl_id = pen.pl_id
4717: and drq.dsgn_typ_cd = 'DPNT'

Line 4728: from ben_dsgn_rqmt_f drq3

4724: and p_effective_date between drq.effective_start_date
4725: and drq.effective_end_date
4726: and (pen.oipl_id IS NULL
4727: OR NOT EXISTS (select null
4728: from ben_dsgn_rqmt_f drq3
4729: where drq3.oipl_id = pen.oipl_id
4730: and p_effective_date between drq3.effective_start_date and drq3.effective_end_date
4731: UNION ALL
4732: select null

Line 4733: from ben_dsgn_rqmt_f drq4,

4729: where drq3.oipl_id = pen.oipl_id
4730: and p_effective_date between drq3.effective_start_date and drq3.effective_end_date
4731: UNION ALL
4732: select null
4733: from ben_dsgn_rqmt_f drq4,
4734: ben_oipl_f cop
4735: where cop.oipl_id = pen.oipl_id
4736: and drq4.opt_id = cop.opt_id
4737: and p_effective_date between cop.effective_start_date and cop.effective_end_date

Line 5054: ben_dsgn_rqmt_f drq

5050: --
5051: cursor c_min_no_grp is
5052: select mn_dpnts_rqd_num
5053: from ben_prtt_enrt_rslt_f perslt,
5054: ben_dsgn_rqmt_f drq
5055: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5056: and perslt.prtt_enrt_rslt_stat_cd is null
5057: and drq.dsgn_typ_cd = 'DPNT'
5058: and drq.grp_rlshp_cd is null

Line 5102: ben_dsgn_rqmt_f drq

5098: --
5099: cursor c_min_typ is
5100: select distinct 'X' -- mn_dpnts_rqd_num
5101: from ben_prtt_enrt_rslt_f perslt,
5102: ben_dsgn_rqmt_f drq
5103: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5104: and drq.dsgn_typ_cd = 'DPNT'
5105: and drq.grp_rlshp_cd is not null
5106: and perslt.prtt_enrt_rslt_stat_cd is null