APPS.BEN_DET_ENRT_RATES dependencies on BEN_PER_IN_LER

Line 207: ben_per_in_ler pil,

203: epe.spcl_rt_oipl_id,
204: epe.fonm_cvg_strt_dt,
205: pel.acty_ref_perd_cd
206: from ben_elig_per_elctbl_chc epe,
207: ben_per_in_ler pil,
208: ben_pil_elctbl_chc_popl pel,
209: ben_prtt_enrt_rslt_f pen
210: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
211: and pil.per_in_ler_id=epe.per_in_ler_id

Line 321: from ben_per_in_ler pil,

317: and prtt_rt_val_stat_cd is null;
318: --
319: cursor c_unrestricted is
320: select 'Y'
321: from ben_per_in_ler pil,
322: ben_ler_f ler
323: where pil.per_in_ler_id = p_per_in_ler_id
324: and pil.ler_id = ler.ler_id
325: and ler.typ_cd = 'SCHEDDU'

Line 351: from ben_per_in_ler pil,

347: pen.object_version_number,
348: pen.pgm_id,
349: pen.pl_id,
350: pen.oipl_id
351: from ben_per_in_ler pil,
352: ben_elig_per_elctbl_chc epe,
353: ben_pil_elctbl_chc_popl pel,
354: ben_enrt_rt ecr1,
355: ben_enrt_rt ecr2,

Line 943: ben_per_in_ler pil

939: ,p_per_in_ler_id number) is
940: select bpl.bnft_prvdd_ldgr_id,
941: bpl.object_version_number
942: from ben_bnft_prvdd_ldgr_f bpl,
943: ben_per_in_ler pil
944: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
945: and bpl.acty_base_rt_id = p_acty_base_rt_id
946: and bpl.used_val is not null
947: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'

Line 958: from ben_per_in_ler pil,

954:
955: --
956: cursor c_unrestricted is
957: select 'Y'
958: from ben_per_in_ler pil,
959: ben_ler_f ler
960: where pil.per_in_ler_id = p_per_in_ler_id
961: and pil.ler_id = ler.ler_id
962: and ler.typ_cd = 'SCHEDDU'

Line 1233: ben_per_in_ler pil

1229: ,p_per_in_ler_id number) is
1230: select bpl.bnft_prvdd_ldgr_id,
1231: bpl.object_version_number
1232: from ben_bnft_prvdd_ldgr_f bpl,
1233: ben_per_in_ler pil
1234: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1235: and bpl.acty_base_rt_id = p_acty_base_rt_id
1236: and bpl.used_val is not null
1237: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'

Line 1247: from ben_per_in_ler pil,

1243: bpl.effective_start_date and bpl.effective_end_date;
1244: --
1245: cursor c_unrestricted is
1246: select 'Y'
1247: from ben_per_in_ler pil,
1248: ben_ler_f ler
1249: where pil.per_in_ler_id = p_per_in_ler_id
1250: and pil.ler_id = ler.ler_id
1251: and ler.typ_cd = 'SCHEDDU'