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 3616: ben_cwb_hrchy hrc

3612: select hrc.emp_pil_elctbl_chc_popl_id,
3613: pel.pil_elctbl_chc_popl_id
3614: from ben_elig_per_elctbl_chc epe,
3615: ben_pil_elctbl_chc_popl pel,
3616: ben_cwb_hrchy hrc
3617: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3618: and epe.elig_per_elctbl_chc_id = cv_emp_epe_id
3619: and hrc.emp_pil_elctbl_chc_popl_id(+) = pel.pil_elctbl_chc_popl_id;
3620: --

Line 7011: insert into ben_cwb_hrchy (

7007: fetch c_hrchy into l_emp_pel_id, l_pel_id;
7008: --
7009: if l_pel_id is not null and l_emp_pel_id is null then
7010: --
7011: insert into ben_cwb_hrchy (
7012: emp_pil_elctbl_chc_popl_id,
7013: mgr_pil_elctbl_chc_popl_id,
7014: lvl_num )
7015: values(