APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ENRT_BNFT

Line 920: -- a. for handling ben_enrt_bnft and b. future completed certifications

916: order by pen.effective_start_date desc;
917: --
918: l_prtt_result c_prtt_result%rowtype;
919: -- Bug 5102337 several changes in this cursor
920: -- a. for handling ben_enrt_bnft and b. future completed certifications
921: cursor c_choice_info is
922: select pil.object_version_number,
923: epe.elig_per_elctbl_chc_id,
924: pel.enrt_typ_cycl_cd,

Line 964: ben_enrt_bnft enb,

960: 'N' stage,
961: 'N' suspended,
962: epe.cryfwd_elig_dpnt_cd
963: from ben_elig_per_elctbl_chc epe,
964: ben_enrt_bnft enb,
965: ben_per_in_ler pil,
966: ben_pil_elctbl_chc_popl pel
967: where NVL(enb.crntly_enrld_flag(+),epe.crntly_enrd_flag) = 'Y'
968: and pil.person_id = p_person_id

Line 1055: from ben_enrt_bnft enb

1051: enb.dflt_flag,
1052: enb.prtt_enrt_rslt_id,
1053: enb.cvg_mlt_cd,
1054: enb.crntly_enrld_flag
1055: from ben_enrt_bnft enb
1056: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
1057: and enb.crntly_enrld_flag = 'Y'
1058: and enb.prtt_enrt_rslt_id is not NULL
1059: and enb.ordr_num = v_bnft_ordr_num

Line 1113: ben_enrt_bnft enb

1109: ecr.rt_strt_dt_cd,
1110: ecr.rt_strt_dt_rl,
1111: nvl(ecr.elig_per_elctbl_chc_id,enb.elig_per_elctbl_chc_id) elig_per_elctbl_chc_id
1112: from ben_enrt_rt ecr,
1113: ben_enrt_bnft enb
1114: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
1115: and ecr.enrt_bnft_id = enb.enrt_bnft_id (+) ;
1116: --
1117: l_ecr c_ecr%rowtype;