APPS.BEN_DET_ENRT_RATES dependencies on BEN_PER_IN_LER

Line 251: ben_per_in_ler pil,

247: epe.spcl_rt_oipl_id,
248: epe.fonm_cvg_strt_dt,
249: pel.acty_ref_perd_cd
250: from ben_elig_per_elctbl_chc epe,
251: ben_per_in_ler pil,
252: ben_pil_elctbl_chc_popl pel,
253: ben_prtt_enrt_rslt_f pen
254: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
255: and pil.per_in_ler_id=epe.per_in_ler_id

Line 365: from ben_per_in_ler pil,

361: and prtt_rt_val_stat_cd is null;
362: --
363: cursor c_unrestricted is
364: select 'Y'
365: from ben_per_in_ler pil,
366: ben_ler_f ler
367: where pil.per_in_ler_id = p_per_in_ler_id
368: and pil.ler_id = ler.ler_id
369: and ler.typ_cd = 'SCHEDDU'

Line 395: from ben_per_in_ler pil,

391: pen.object_version_number,
392: pen.pgm_id,
393: pen.pl_id,
394: pen.oipl_id
395: from ben_per_in_ler pil,
396: ben_elig_per_elctbl_chc epe,
397: ben_pil_elctbl_chc_popl pel,
398: ben_enrt_rt ecr1,
399: ben_enrt_rt ecr2,

Line 1008: ben_per_in_ler pil

1004: ,p_per_in_ler_id number) is
1005: select bpl.bnft_prvdd_ldgr_id,
1006: bpl.object_version_number
1007: from ben_bnft_prvdd_ldgr_f bpl,
1008: ben_per_in_ler pil
1009: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1010: and bpl.acty_base_rt_id = p_acty_base_rt_id
1011: and bpl.used_val is not null
1012: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'

Line 1023: from ben_per_in_ler pil,

1019:
1020: --
1021: cursor c_unrestricted is
1022: select 'Y'
1023: from ben_per_in_ler pil,
1024: ben_ler_f ler
1025: where pil.per_in_ler_id = p_per_in_ler_id
1026: and pil.ler_id = ler.ler_id
1027: and ler.typ_cd = 'SCHEDDU'

Line 1298: ben_per_in_ler pil

1294: ,p_per_in_ler_id number) is
1295: select bpl.bnft_prvdd_ldgr_id,
1296: bpl.object_version_number
1297: from ben_bnft_prvdd_ldgr_f bpl,
1298: ben_per_in_ler pil
1299: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1300: and bpl.acty_base_rt_id = p_acty_base_rt_id
1301: and bpl.used_val is not null
1302: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'

Line 1312: from ben_per_in_ler pil,

1308: bpl.effective_start_date and bpl.effective_end_date;
1309: --
1310: cursor c_unrestricted is
1311: select 'Y'
1312: from ben_per_in_ler pil,
1313: ben_ler_f ler
1314: where pil.per_in_ler_id = p_per_in_ler_id
1315: and pil.ler_id = ler.ler_id
1316: and ler.typ_cd = 'SCHEDDU'

Line 1547: from ben_prtt_rt_val prv, ben_per_in_ler pil

1543: -----Bug 8214477
1544: cursor c_prv(p_prtt_enrt_rslt_id number)
1545: is
1546: select prtt_rt_val_id, rt_strt_dt
1547: from ben_prtt_rt_val prv, ben_per_in_ler pil
1548: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1549: and prv.rt_end_dt = hr_api.g_eot
1550: and prv.per_in_ler_id = pil.per_in_ler_id
1551: and prv.per_in_ler_id = p_per_in_ler_id --------- Bug 8342612