APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1292: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)

1288: -- BEN_PRTT_RT_VAL (PRV)
1289: -- BEN_PRTT_REIMBMT_RQST_F
1290: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1291: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1292: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1293: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1294: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1295: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)
1296: -- BEN_ELIG_CVRD_DPNT_F (PDP)

Line 3264: from ben_elig_per_elctbl_chc epe

3260: -- Get the epe info to store the link between epe and pen rows.
3261: --
3262: cursor c_epe(v_prtt_enrt_rslt_id in number, v_per_in_ler_id in number) is
3263: select epe.*
3264: from ben_elig_per_elctbl_chc epe
3265: where epe.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3266: and nvl(epe.per_in_ler_id , -1) = nvl(v_per_in_ler_id, -1)
3267: and epe.business_group_id = p_business_group_id;
3268: --