APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 93: from ben_elig_per_elctbl_chc epe

89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
90: --
91: cursor c_epe(p_epe_id number) is
92: select enrt_cvg_strt_dt,pl_typ_id
93: from ben_elig_per_elctbl_chc epe
94: where epe.elig_per_elctbl_chc_id = p_epe_id ;
95: --
96: l_epe c_epe%rowtype;
97: --

Line 125: from ben_elig_per_elctbl_chc epe

121: and p_effective_date between abr.effective_start_date and abr.effective_end_date ;
122: --
123: cursor c_flx_epe_ecr(c_per_in_ler_id number ) is
124: select epe.elig_per_elctbl_chc_id
125: from ben_elig_per_elctbl_chc epe
126: where epe.per_in_ler_id = c_per_in_ler_id
127: and epe.bnft_prvdr_pool_id is not null
128: and epe.elig_per_elctbl_chc_id
129: not in ( select ecr.elig_per_elctbl_chc_id from ben_enrt_rt ecr

Line 163: from ben_elig_per_elctbl_chc epe

159: pln.effective_start_date and pln.effective_end_date
160: and p_effective_date between
161: ptip.effective_start_date and ptip.effective_end_date
162: and not exists ( select elig_per_elctbl_chc_id
163: from ben_elig_per_elctbl_chc epe
164: where epe.pgm_id = p_pgm_id
165: and epe.pl_id = pln.pl_id
166: and epe.per_in_ler_id = p_per_in_ler_id
167: and epe.comp_lvl_cd = 'PLANFC' );

Line 187: from ben_elig_per_elctbl_chc epe

183: pln.effective_start_date and pln.effective_end_date
184: and p_effective_date between
185: ptip.effective_start_date and ptip.effective_end_date
186: and not exists ( select elig_per_elctbl_chc_id
187: from ben_elig_per_elctbl_chc epe
188: where epe.pgm_id = p_pgm_id
189: and epe.pl_id = pln.pl_id
190: and epe.per_in_ler_id = p_per_in_ler_id
191: and epe.comp_lvl_cd = 'PLANIMP' );

Line 564: from ben_elig_per_elctbl_chc epe

560: l_enb_object_version_number number;
561: -- cursors declaration
562: cursor c_epe is
563: select object_version_number,per_in_ler_id
564: from ben_elig_per_elctbl_chc epe
565: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id ;
566: --
567: cursor c_enb is
568: select object_version_number

Line 1112: ben_elig_per_elctbl_chc epe

1108: pil.ler_id,
1109: epe.elig_per_elctbl_chc_id
1110: from ben_enrt_prem ecr,
1111: ben_per_in_ler pil,
1112: ben_elig_per_elctbl_chc epe
1113: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1114: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1115: and pil.per_in_ler_id = epe.per_in_ler_id
1116: and pil.per_in_ler_id = p_per_in_ler_id ;

Line 1146: ben_elig_per_elctbl_chc epe

1142: cursor c_pel is
1143: select pel.enrt_perd_id,
1144: pel.lee_rsn_id
1145: from ben_pil_elctbl_chc_popl pel,
1146: ben_elig_per_elctbl_chc epe
1147: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1148: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
1149:
1150: l_pel c_pel%rowtype;