DBA Data[Home] [Help]

APPS.BEN_ACTY_BASE_RATE_API dependencies on BEN_PER_IN_LER

Line 1389: ben_per_in_ler pil

1385: cursor c_chk_ecr is
1386: select 'x'
1387: from ben_enrt_rt ecr,
1388: ben_elig_per_elctbl_chc epe,
1389: ben_per_in_ler pil
1390: where ecr.acty_base_rt_id = p_acty_base_rt_id
1391: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1392: and pil.per_in_ler_id = epe.per_in_ler_id
1393: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 1399: ben_per_in_ler pil

1395: select 'x'
1396: from ben_enrt_rt ecr,
1397: ben_enrt_bnft enb,
1398: ben_elig_per_elctbl_chc epe,
1399: ben_per_in_ler pil
1400: where ecr.acty_base_rt_id = p_acty_base_rt_id
1401: and enb.enrt_bnft_id = ecr.enrt_bnft_id
1402: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
1403: and pil.per_in_ler_id = epe.per_in_ler_id