DBA Data[Home] [Help]

APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 372: ben_elig_per_elctbl_chc epe

368: enb.elig_per_elctbl_chc_id,
369: enb.enrt_bnft_id
370: from ben_prtt_enrt_rslt_f pen,
371: ben_enrt_bnft enb,
372: ben_elig_per_elctbl_chc epe
373: where pen.person_id = c_person_id
374: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd
375: or pen.enrt_mthd_cd = 'O'
376: or ( (pen.enrt_mthd_cd = 'D' or pen.enrt_mthd_cd = 'E') --7447088 --Bug 12938378: Check for Explicit enrollments

Line 406: ben_elig_per_elctbl_chc epe,

402: prv.rt_val,
403: prv.ann_rt_val,
404: prv.prtt_rt_val_id
405: from ben_prtt_rt_val prv,
406: ben_elig_per_elctbl_chc epe,
407: ben_enrt_bnft enb,
408: ben_enrt_rt ecr
409: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
410: and prv.prtt_rt_val_stat_cd is null