APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_ENRT_RT

Line 437: ,ben_enrt_rt ecr

433: cursor c_get_elctbl_chc is
434: select min(ecr.rt_strt_dt) rt_strt_dt
435: ,epe.ptip_id
436: from ben_elig_per_elctbl_chc epe
437: ,ben_enrt_rt ecr
438: ,ben_enrt_bnft enb
439: where epe.per_in_ler_id = p_per_in_ler_id
440: and epe.business_group_id = p_business_group_id
441: and decode(ecr.enrt_bnft_id, null, ecr.elig_per_elctbl_chc_id,

Line 878: update ben_enrt_rt set prtt_rt_val_id = null

874: if c_epe%notfound then
875: exit;
876: end if;
877: --
878: update ben_enrt_rt set prtt_rt_val_id = null
879: where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id;
880: end loop;
881: close c_epe;
882:

Line 1351: update ben_enrt_rt set prtt_rt_val_id = null

1347: if c_epe%notfound then
1348: exit;
1349: end if;
1350: --
1351: update ben_enrt_rt set prtt_rt_val_id = null
1352: where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id;
1353: end loop;
1354: close c_epe;
1355: --