DBA Data[Home] [Help]

APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on BEN_ENRT_BNFT

Line 371: ben_enrt_bnft enb,

367: select pen.*,
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'

Line 407: ben_enrt_bnft enb,

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
411: and ecr.entr_val_at_enrt_flag = 'Y'