DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 3615: ben_pil_elctbl_chc_popl pel,

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