APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 618: from ben_elig_per_elctbl_chc epe,

614: -- open c_pl_opt_name cursor only if error needs to be displayed.
615: --
616: cursor c_pl_opt_name is
617: select pln.name || ' '|| opt.name
618: from ben_elig_per_elctbl_chc epe,
619: ben_pl_f pln,
620: ben_oipl_f oipl,
621: ben_opt_f opt
622: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 693: from ben_elig_per_elctbl_chc epe,

689: pel.enrt_perd_strt_dt,
690: pel.acty_ref_perd_cd,
691: pil.person_id,
692: pil.ler_id
693: from ben_elig_per_elctbl_chc epe,
694: ben_per_in_ler pil,
695: ben_pil_elctbl_chc_popl pel
696: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
697: and epe.per_in_ler_id = pil.per_in_ler_id

Line 782: ben_elig_per_elctbl_chc epe,

778: select
779: enb.enrt_bnft_id
780: from
781: ben_enrt_bnft enb,
782: ben_elig_per_elctbl_chc epe,
783: ben_elig_per_elctbl_chc epe_fc
784: where
785: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
786: and epe.pgm_id = epe_fc.pgm_id

Line 783: ben_elig_per_elctbl_chc epe_fc

779: enb.enrt_bnft_id
780: from
781: ben_enrt_bnft enb,
782: ben_elig_per_elctbl_chc epe,
783: ben_elig_per_elctbl_chc epe_fc
784: where
785: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
786: and epe.pgm_id = epe_fc.pgm_id
787: and nvl(epe.oipl_id,-99999) = nvl(epe_fc.oipl_id,-99999)

Line 888: from ben_elig_per_elctbl_chc epe

884: between abp.effective_start_date
885: and abp.effective_end_date
886: and abp.bnft_prvdr_pool_id in
887: (select epe.bnft_prvdr_pool_id
888: from ben_elig_per_elctbl_chc epe
889: where epe.pgm_id = l_epe.pgm_id
890: and epe.per_in_ler_id = l_epe.per_in_ler_id);
891:
892:

Line 914: ben_elig_per_elctbl_chc epe

910: prv.rt_strt_dt,
911: prv.rt_end_dt
912: from ben_prtt_rt_val prv,
913: ben_prtt_enrt_rslt_f pen,
914: ben_elig_per_elctbl_chc epe
915: where epe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
916: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
917: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
918: and pen.prtt_enrt_rslt_stat_cd is null

Line 1046: ben_elig_per_elctbl_chc epe

1042: is
1043: select ecr.val
1044: from ben_enrt_prem ecr,
1045: ben_per_in_ler pil,
1046: ben_elig_per_elctbl_chc epe
1047: where ecr.actl_prem_id = p_actl_prem_id
1048: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1049: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1050: and pil.per_in_ler_id = epe.per_in_ler_id

Line 1082: ben_elig_per_elctbl_chc epe

1078: is
1079: select auto_distr_flag
1080: from ben_enrt_perd enp,
1081: ben_pil_elctbl_chc_popl pel,
1082: ben_elig_per_elctbl_chc epe
1083: where enp.enrt_perd_id = pel.enrt_perd_id
1084: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1085: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
1086: -- and enp.business_group_id = p_business_group_id;

Line 1094: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr

1090: --
1091: cursor get_rt_and_element(c_pgm_id in number,
1092: c_per_in_ler_id in number) is
1093: select abr.acty_base_rt_id, abr.element_type_id, epe.elig_per_elctbl_chc_id
1094: from ben_elig_per_elctbl_chc epe, ben_acty_base_rt_f abr
1095: where (epe.pl_id = abr.pl_id or epe.plip_id = abr.plip_id)
1096: and epe.pgm_id = c_pgm_id and epe.per_in_ler_id = c_per_in_ler_id
1097: and epe.comp_lvl_cd = 'PLANFC';
1098: l_rt_and_element get_rt_and_element%rowtype;