APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 184: from ben_elig_per_elctbl_chc epe

180: epe.PGM_ID,
181: epe.PL_TYP_ID,
182: epe.PER_IN_LER_ID,
183: nvl(epe.prtt_enrt_rslt_id,-1) prtt_enrt_rslt_id
184: from ben_elig_per_elctbl_chc epe
185: where epe.per_in_ler_id = p_per_in_ler_id
186: and epe.business_group_id = p_business_group_id
187: and epe.pl_id = p_pl_id
188: and epe.oipl_id is null

Line 1009: ben_elig_per_elctbl_chc epe

1005: --
1006: cursor c_imp_plan_exists is
1007: select 'Y'
1008: from ben_pl_f pln,
1009: ben_elig_per_elctbl_chc epe
1010: where pln.subj_to_imptd_incm_typ_cd is not null
1011: and pln.pl_id = epe.pl_id
1012: and epe.per_in_ler_id = p_per_in_ler_id
1013: and pln.pl_stat_cd = 'A'

Line 1027: and exists (select null from ben_elig_per_elctbl_chc epe

1023: and pen.comp_lvl_cd = 'PLANIMP'
1024: and pen.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
1025: and pen.prtt_enrt_rslt_stat_cd is null
1026: and pen.enrt_cvg_thru_dt = to_date('31-12-4712','dd-mm-yyyy')
1027: and exists (select null from ben_elig_per_elctbl_chc epe
1028: where pen.pl_id = epe.pl_id
1029: and epe.per_in_ler_id = p_per_in_ler_id);
1030: --
1031: l_exists varchar2(30) := 'N';