[Home] [Help]
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.
81: 20 Jul 04 pbodla 115.29 Added logic for single person run.
201: 18-Oct-06 maagrawa 115.76 4587770.Tuned c_no_0_hrchy
202: 01-dec-06 ssarkar 115.77 5124534 : modified popu_missing_person_pil
203: 13-dec-06 ssarkar 115.78 5124534/5702794 : populate cwb_group_persons with pl_id/oipl_id
204: 20-Feb-07 maagrawa 115.79 Further tuned c_no_0_hrchy. Use
205: ben_cwb_person_info instead of
206: ben_per_in_ler.
207: 04-Jun-07 maagrawa 115.80 Further tuned c_no_0_hrchy. Check only
208: level 1 hierarchy.
209: 24-Sep-08 sgnanama 115.81 7393142: process for terminated employee
830: cursor c_no_0_hrchy(p_pl_id number,
831: p_lf_evt_ocrd_dt date) is
832: select unique hrh_0.mgr_per_in_ler_id
833: from ben_cwb_group_hrchy hrh_0,
834: ben_cwb_person_info mgr_info_0
835: where mgr_info_0.group_per_in_ler_id = hrh_0.emp_per_in_ler_id
836: and mgr_info_0.group_pl_id = p_pl_id
837: and mgr_info_0.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
838: and hrh_0.lvl_num = 1
1513: if p_use_eff_dt_flag = 'N' then
1514: l_effective_date := null;
1515: end if;
1516: --
1517: BEN_CWB_PERSON_INFO_PKG.refresh_person_info
1518: (p_group_per_in_ler_id => p_group_per_in_ler_id,
1519: p_effective_date => l_effective_date,
1520: p_called_from_benmngle => true);
1521: --
1796: ptnl.ptnl_ler_for_per_id,
1797: ptnl.object_version_number ptnl_ovn
1798: from ben_per_in_ler pil,
1799: ben_ptnl_ler_for_per ptnl,
1800: ben_cwb_person_info cpi
1801: where pil.group_pl_id = cv_group_pl_id
1802: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1803: and pil.per_in_ler_stat_cd = 'STRTD'
1804: and cpi.group_per_in_ler_id = pil.per_in_ler_id