DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 665: ben_elig_per_elctbl_chc epe

661: pil.ler_id,
662: epe.business_group_id,
663: epe.enrt_cvg_strt_dt
664: from ben_per_in_ler pil,
665: ben_elig_per_elctbl_chc epe
666: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
667: and epe.per_in_ler_id = pil.per_in_ler_id;
668: --
669: cursor c_opt(l_oipl_id number) is

Line 889: ben_elig_per_elctbl_chc epe

885: cursor c_pil_popl is
886: select pel.enrt_perd_end_dt,
887: pel.procg_end_dt
888: from ben_pil_elctbl_chc_popl pel,
889: ben_elig_per_elctbl_chc epe
890: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
891: and epe.business_group_id = l_business_group_id
892: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
893: and pel.business_group_id = l_business_group_id;

Line 7155: ben_elig_per_elctbl_chc epe,

7151: epe.per_in_ler_id,
7152: pil.person_id,
7153: epe.fonm_cvg_strt_dt
7154: from
7155: ben_elig_per_elctbl_chc epe,
7156: ben_pil_elctbl_chc_popl pel,
7157: ben_per_in_ler pil
7158: where
7159: epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and