DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 5035: ben_elig_per_elctbl_chc epe,

5031: --
5032: cursor c_pen_bnft_amt is
5033: select pen.bnft_amt
5034: from ben_prtt_enrt_rslt_f pen,
5035: ben_elig_per_elctbl_chc epe,
5036: ben_enrt_bnft enb
5037: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5038: and enb.enrt_bnft_id = p_enrt_bnft_id
5039: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id

Line 6115: from ben_elig_per_elctbl_chc epe,

6111: l_enrt_perd_strt_dt date;
6112: --
6113: cursor c_epe is
6114: select epo.ENRT_PERD_STRT_DT
6115: from ben_elig_per_elctbl_chc epe,
6116: ben_pil_elctbl_chc_popl epo
6117: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
6118: and epe.pil_elctbl_chc_popl_id = epo.pil_elctbl_chc_popl_id ;
6119: --