DBA Data[Home] [Help]

APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_BNFT

Line 362: ben_enrt_bnft enb,

358: select pen.*,
359: enb.elig_per_elctbl_chc_id,
360: enb.enrt_bnft_id
361: from ben_prtt_enrt_rslt_f pen,
362: ben_enrt_bnft enb,
363: ben_elig_per_elctbl_chc epe
364: where pen.person_id = c_person_id
365: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd
366: or pen.enrt_mthd_cd = 'O'

Line 392: ben_enrt_bnft enb,

388: prv.ann_rt_val,
389: prv.prtt_rt_val_id
390: from ben_prtt_rt_val prv,
391: ben_elig_per_elctbl_chc epe,
392: ben_enrt_bnft enb,
393: ben_enrt_rt ecr
394: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
395: and prv.prtt_rt_val_stat_cd is null
396: and ecr.entr_val_at_enrt_flag = 'Y'