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 2702: BEN_CWB_PL_DSGN_PKG.refresh_pl_dsgn(p_group_pl_id => l_pl_id

2698: -- Populate ben_cwb_plan_design, it should be committed as 9999 autonmous trxn.
2699: --
2700: -- refresh plan design will be smart enough to refresh or not.
2701: --
2702: BEN_CWB_PL_DSGN_PKG.refresh_pl_dsgn(p_group_pl_id => l_pl_id
2703: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
2704: ,p_effective_date => null);
2705: --
2706: if nvl(p_online_call_flag, 'N') = 'N' then

Line 3981: FROM ben_cwb_pl_dsgn

3977: --
3978: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
3979: IS
3980: SELECT group_oipl_id
3981: FROM ben_cwb_pl_dsgn
3982: WHERE group_pl_id = c_group_pl_id
3983: AND pl_id = group_pl_id
3984: AND lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt;
3985: