APPS.BEN_ELECTION_INFORMATION dependencies on BEN_PER_IN_LER

Line 1217: from ben_per_in_ler pil,

1213: and prtt_rt_val_stat_cd IS NULL ; --BUG 4938498
1214: --
1215: cursor c_unrestricted is
1216: select null
1217: from ben_per_in_ler pil,
1218: ben_ler_f ler
1219: where pil.per_in_ler_id = p_per_in_ler_id
1220: and pil.ler_id = ler.ler_id
1221: and ler.typ_cd = 'SCHEDDU'

Line 1379: from ben_per_in_ler pil, ben_per_in_ler pil2

1375: --
1376: -- 7206471
1377: cursor c_get_prior_per_in_ler is
1378: select 'Y'
1379: from ben_per_in_ler pil, ben_per_in_ler pil2
1380: where pil.per_in_ler_id <> p_per_in_ler_id
1381: and trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')
1382: and pil2.per_in_ler_id = p_per_in_ler_id
1383: and pil2.person_id = p_person_id

Line 4575: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

4571: -- Added for bug 7206471
4572: --
4573: cursor c_get_prior_per_in_ler is
4574: select 'Y'
4575: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
4576: ben_per_in_ler pil2
4577: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
4578: and pil.per_in_ler_id <> epe.per_in_ler_id
4579: and trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')

Line 4576: ben_per_in_ler pil2

4572: --
4573: cursor c_get_prior_per_in_ler is
4574: select 'Y'
4575: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
4576: ben_per_in_ler pil2
4577: where epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
4578: and pil.per_in_ler_id <> epe.per_in_ler_id
4579: and trunc(pil.lf_evt_ocrd_dt, 'MM') = trunc(pil2.lf_evt_ocrd_dt, 'MM')
4580: and pil2.per_in_ler_id = epe.per_in_ler_id

Line 4614: ,ben_per_in_ler pil

4610: ) is
4611: select pen.*, epe.per_in_ler_id pil_id
4612: from ben_prtt_enrt_rslt_f pen
4613: ,ben_ptip_f ptip
4614: ,ben_per_in_ler pil
4615: ,ben_elig_per_elctbl_chc epe
4616: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
4617: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
4618: and pen.prtt_enrt_rslt_stat_cd is null

Line 6969: ben_per_in_ler pil

6965: select ebr.enrt_bnft_id,
6966: ebr.object_version_number
6967: from ben_enrt_bnft ebr,
6968: ben_elig_per_elctbl_chc epe,
6969: ben_per_in_ler pil
6970: where ebr.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id and
6971: ( p_enrt_bnft_id is null OR
6972: ebr.enrt_bnft_id <> p_enrt_bnft_id )
6973: and epe.elig_per_elctbl_chc_id=ebr.elig_per_elctbl_chc_id