DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 263: from ben_elig_per_elctbl_chc epe

259:
260: --------------Bug 9135034
261: cursor c_epe is
262: select epe.fonm_cvg_strt_dt
263: from ben_elig_per_elctbl_chc epe
264: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id ;
265: l_fonm_cvg_strt_dt1 date;
266: ---------------Bug 9135034
267: l_jurisdiction_code varchar2(30);

Line 750: from ben_elig_per_elctbl_chc

746:
747: --9774358
748: cursor c_epe is
749: select elig_per_elctbl_chc_id
750: from ben_elig_per_elctbl_chc
751: where per_in_ler_id = p_per_in_ler_id
752: and nvl(pgm_id, -1) = nvl(p_pgm_id ,-1)
753: and nvl(pl_typ_id, -1) = nvl(p_pl_typ_id,-1)
754: and nvl(pl_id, -1) = nvl(p_pl_id,-1)