APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 601: from ben_elig_per_elctbl_chc epe,

597: -- open c_pl_opt_name cursor only if error needs to be displayed.
598: --
599: cursor c_pl_opt_name is
600: select pln.name || ' '|| opt.name
601: from ben_elig_per_elctbl_chc epe,
602: ben_pl_f pln,
603: ben_oipl_f oipl,
604: ben_opt_f opt
605: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 676: from ben_elig_per_elctbl_chc epe,

672: pel.enrt_perd_strt_dt,
673: pel.acty_ref_perd_cd,
674: pil.person_id,
675: pil.ler_id
676: from ben_elig_per_elctbl_chc epe,
677: ben_per_in_ler pil,
678: ben_pil_elctbl_chc_popl pel
679: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
680: and epe.per_in_ler_id = pil.per_in_ler_id

Line 765: ben_elig_per_elctbl_chc epe,

761: select
762: enb.enrt_bnft_id
763: from
764: ben_enrt_bnft enb,
765: ben_elig_per_elctbl_chc epe,
766: ben_elig_per_elctbl_chc epe_fc
767: where
768: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
769: and epe.pgm_id = epe_fc.pgm_id

Line 766: ben_elig_per_elctbl_chc epe_fc

762: enb.enrt_bnft_id
763: from
764: ben_enrt_bnft enb,
765: ben_elig_per_elctbl_chc epe,
766: ben_elig_per_elctbl_chc epe_fc
767: where
768: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
769: and epe.pgm_id = epe_fc.pgm_id
770: and nvl(epe.oipl_id,-99999) = nvl(epe_fc.oipl_id,-99999)

Line 871: from ben_elig_per_elctbl_chc epe

867: between abp.effective_start_date
868: and abp.effective_end_date
869: and abp.bnft_prvdr_pool_id in
870: (select epe.bnft_prvdr_pool_id
871: from ben_elig_per_elctbl_chc epe
872: where epe.pgm_id = l_epe.pgm_id
873: and epe.per_in_ler_id = l_epe.per_in_ler_id);
874:
875:

Line 897: ben_elig_per_elctbl_chc epe

893: prv.rt_strt_dt,
894: prv.rt_end_dt
895: from ben_prtt_rt_val prv,
896: ben_prtt_enrt_rslt_f pen,
897: ben_elig_per_elctbl_chc epe
898: where epe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
899: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
900: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
901: and pen.prtt_enrt_rslt_stat_cd is null

Line 1029: ben_elig_per_elctbl_chc epe

1025: is
1026: select ecr.val
1027: from ben_enrt_prem ecr,
1028: ben_per_in_ler pil,
1029: ben_elig_per_elctbl_chc epe
1030: where ecr.actl_prem_id = p_actl_prem_id
1031: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1032: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1033: and pil.per_in_ler_id = epe.per_in_ler_id

Line 1065: ben_elig_per_elctbl_chc epe

1061: is
1062: select auto_distr_flag
1063: from ben_enrt_perd enp,
1064: ben_pil_elctbl_chc_popl pel,
1065: ben_elig_per_elctbl_chc epe
1066: where enp.enrt_perd_id = pel.enrt_perd_id
1067: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1068: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
1069: -- and enp.business_group_id = p_business_group_id;

Line 1077: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr

1073: --
1074: cursor get_rt_and_element(c_pgm_id in number,
1075: c_per_in_ler_id in number) is
1076: select abr.acty_base_rt_id, abr.element_type_id, epe.elig_per_elctbl_chc_id
1077: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr
1078: where (epe.pl_id = abr.pl_id or epe.plip_id = abr.plip_id)
1079: and epe.pgm_id = c_pgm_id and epe.per_in_ler_id = c_per_in_ler_id
1080: and epe.comp_lvl_cd = 'PLANFC';
1081: l_rt_and_element get_rt_and_element%rowtype;