APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_CWB_PL_DSGN

Line 76: ben_cwb_pl_dsgn_pkg and

72: flag is N.
73: 26 May 04 pbodla 115.25 Added cursor get_per_info
74: to be used for online calls.
75: 10 Jun 04 maagrawa 115.26 Pass null as effective_date to
76: ben_cwb_pl_dsgn_pkg and
77: ben_cwb_person_info_pkg
78: 12 Jul 04 pbodla 115.27 Bug 3748539: This situation indicates
79: it is a recursive supervisory heirarchy.
80: 13 Jul 04 pbodla 115.28 Bug 3748539: Added MGRPERSONID token.

Line 2747: BEN_CWB_PL_DSGN_PKG.refresh_pl_dsgn(p_group_pl_id => l_pl_id

2743: -- Populate ben_cwb_plan_design, it should be committed as 9999 autonmous trxn.
2744: --
2745: -- refresh plan design will be smart enough to refresh or not.
2746: --
2747: BEN_CWB_PL_DSGN_PKG.refresh_pl_dsgn(p_group_pl_id => l_pl_id
2748: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
2749: ,p_effective_date => null);
2750: --
2751: if nvl(p_online_call_flag, 'N') = 'N' then

Line 4033: FROM ben_cwb_pl_dsgn

4029: --
4030: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
4031: IS
4032: SELECT group_oipl_id
4033: FROM ben_cwb_pl_dsgn
4034: WHERE group_pl_id = c_group_pl_id
4035: AND pl_id = group_pl_id
4036: AND lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt;
4037: