DBA Data[Home] [Help]

APPS.BEN_ACTY_BASE_RATE_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1388: ben_elig_per_elctbl_chc epe,

1384: --
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

Line 1398: ben_elig_per_elctbl_chc epe,

1394: union
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