DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 3661: ben_pil_elctbl_chc_popl pel,

3657: cursor c_hrchy(cv_emp_epe_id number) is
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;