APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1348: From ben_elig_per_elctbl_chc epe

1344: ,epe.BUSINESS_GROUP_ID
1345: ,'DEF' actn_cd
1346: ,'N' Suspended
1347: ,epe.in_pndg_wkflow_flag
1348: From ben_elig_per_elctbl_chc epe
1349: Where epe.Auto_enrt_flag = 'N'
1350: and epe.per_in_ler_id = p_per_in_ler_id
1351: and epe.Business_group_id = p_business_group_id
1352: and (epe.elctbl_flag = 'Y' or epe.mndtry_flag = 'Y')

Line 1423: From ben_elig_per_elctbl_chc epe

1419: ,epe.BUSINESS_GROUP_ID
1420: ,'DEF' actn_cd
1421: ,'N' Suspended
1422: ,epe.in_pndg_wkflow_flag
1423: From ben_elig_per_elctbl_chc epe
1424: Where epe.dflt_flag = 'N'
1425: and epe.crntly_enrd_flag = 'N'
1426: and epe.mndtry_flag = 'Y'
1427: and epe.Auto_enrt_flag = 'N'

Line 1493: , ben_elig_per_elctbl_chc epe

1489: --Start AMN Bug 14006027
1490: cursor c_pl_enrt_dt(v_elig_per_elctbl_chc_id number) is
1491: SELECT pel.enrt_perd_strt_dt
1492: FROM ben_pil_elctbl_chc_popl pel
1493: , ben_elig_per_elctbl_chc epe
1494: WHERE pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1495: AND epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1496:
1497: l_pl_enrt_dt c_pl_enrt_dt%rowtype;