APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_CWB_HRCHY

Line 504: 12-Jul-05 pbodla 115.230 Populating data into ben_cwb_hrchy is

500: pick up valid enrollments only.
501: 08-Jul-05 rbingi 115.229 Bug 4447114 : assigning Global value of
502: ben_evaluate_elig_profiles.g_inelg_rsn_cd
503: to l_inelg_rsn_cd in case of CWB run mode
504: 12-Jul-05 pbodla 115.230 Populating data into ben_cwb_hrchy is
505: completely removed.
506: 21-Jul-05 kmahendr 115.231 Bug#4478186 - added codes to procedure
507: enrt_perd_strt_dt
508: 10-Nov-05 tjesumic 115.233 fix 115.232 (4571771) is reversed as the benauten electable flag

Line 3662: ben_cwb_hrchy hrc

3658: select hrc.emp_pil_elctbl_chc_popl_id,
3659: pel.pil_elctbl_chc_popl_id
3660: from ben_elig_per_elctbl_chc epe,
3661: ben_pil_elctbl_chc_popl pel,
3662: ben_cwb_hrchy hrc
3663: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3664: and epe.elig_per_elctbl_chc_id = cv_emp_epe_id
3665: and hrc.emp_pil_elctbl_chc_popl_id(+) = pel.pil_elctbl_chc_popl_id;
3666: --

Line 7145: insert into ben_cwb_hrchy (

7141: fetch c_hrchy into l_emp_pel_id, l_pel_id;
7142: --
7143: if l_pel_id is not null and l_emp_pel_id is null then
7144: --
7145: insert into ben_cwb_hrchy (
7146: emp_pil_elctbl_chc_popl_id,
7147: mgr_pil_elctbl_chc_popl_id,
7148: lvl_num )
7149: values(