[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
860: p_lf_evt_ocrd_dt date) is
861: select /*+ leading(MGR_INFO_0) use_nl(HRH_0)*/ unique hrh_0.mgr_per_in_ler_id
862: -- Bug 12717230
863: from ben_cwb_group_hrchy hrh_0,
864: ben_cwb_person_info mgr_info_0
865: where mgr_info_0.group_per_in_ler_id = hrh_0.emp_per_in_ler_id
866: and mgr_info_0.group_pl_id = p_pl_id
867: and mgr_info_0.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
868: and hrh_0.lvl_num = 1
1550: if p_use_eff_dt_flag = 'N' then
1551: l_effective_date := null;
1552: end if;
1553: --
1554: BEN_CWB_PERSON_INFO_PKG.refresh_person_info
1555: (p_group_per_in_ler_id => p_group_per_in_ler_id,
1556: p_effective_date => l_effective_date,
1557: p_called_from_benmngle => true);
1558:
1841: ptnl.ptnl_ler_for_per_id,
1842: ptnl.object_version_number ptnl_ovn
1843: from ben_per_in_ler pil,
1844: ben_ptnl_ler_for_per ptnl,
1845: ben_cwb_person_info cpi
1846: where pil.group_pl_id = cv_group_pl_id
1847: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1848: and pil.per_in_ler_stat_cd = 'STRTD'
1849: and cpi.group_per_in_ler_id = pil.per_in_ler_id