APPS.BEN_ACTY_BASE_RATE_API dependencies on BEN_ENRT_RT

Line 1387: from ben_enrt_rt ecr,

1383: l_error boolean;
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

Line 1396: from ben_enrt_rt ecr,

1392: and pil.per_in_ler_id = epe.per_in_ler_id
1393: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
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

Line 1423: -- in ben_prtt_rt, ben_enrt_rt tables for delete modes FUTURE_CHANGE, DELETE_NEXT_CHANGE.

1419: --
1420: hr_utility.set_location(l_proc, 20);
1421: --
1422: -- Bug 3636162, Following If condition added so as to avoid the check for records
1423: -- in ben_prtt_rt, ben_enrt_rt tables for delete modes FUTURE_CHANGE, DELETE_NEXT_CHANGE.
1424: --
1425: if p_datetrack_mode not in ('DELETE_NEXT_CHANGE','FUTURE_CHANGE') then
1426: open c_chk_ecr;
1427: fetch c_chk_ecr into l_dummy;