APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 508: ben_elig_per_elctbl_chc epe

504: epe.prtt_enrt_rslt_id
505: from
506: ben_prtt_enrt_rslt_f pen,
507: ben_per_in_ler pil,
508: ben_elig_per_elctbl_chc epe
509: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
510: and pen.effective_end_date = hr_api.g_eot
511: and pen.enrt_cvg_thru_dt = hr_api.g_eot
512: and pen.prtt_enrt_rslt_stat_cd is null

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

1636: -- BEN_PRTT_RT_VAL (PRV)
1637: -- BEN_PRTT_REIMBMT_RQST_F
1638: -- BEN_PL_BNF_CTFN_PRVDD_F (PBC)(join to pil to check status)
1639: -- BEN_PRTT_ENRT_CTFN_PRVDD_F (PCS)(join to pil to check status)
1640: -- BEN_ELIG_PER_ELCTBL_CHC (EPE) (not deleted, join to pil to check status)
1641: -- BEN_ENRT_BNFT (ENB) (cascade delete in epe api, but epe not deleted)
1642: -- BEN_ENRT_RT (ECR) (cascade delete in epe api, but epe not deleted)
1643: -- BEN_ENRT_CVG_N_RT_CTFN (ECC) (cascade delete in epe api, but epe not deleted)
1644: -- BEN_ELIG_CVRD_DPNT_F (PDP)

Line 3716: from ben_elig_per_elctbl_chc epe

3712: -- Get the epe info to store the link between epe and pen rows.
3713: --
3714: cursor c_epe(v_prtt_enrt_rslt_id in number, v_per_in_ler_id in number) is
3715: select epe.*
3716: from ben_elig_per_elctbl_chc epe
3717: where epe.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3718: and nvl(epe.per_in_ler_id , -1) = nvl(v_per_in_ler_id, -1)
3719: and epe.business_group_id = p_business_group_id;
3720: --