APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ENRT_RT

Line 2747: from ben_enrt_rt ecr

2743:
2744: cursor c_rate is
2745: /* select ecr.enrt_rt_id,
2746: ecr.object_version_number
2747: from ben_enrt_rt ecr
2748: where elig_per_elctbl_chc_id in
2749: (select elig_per_elctbl_chc_id
2750: from ben_elig_per_elctbl_chc
2751: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2760: from ben_enrt_rt ecr

2756: */
2757:
2758: select ecr.enrt_rt_id,
2759: ecr.object_version_number
2760: from ben_enrt_rt ecr
2761: where elig_per_elctbl_chc_id in
2762: (select elig_per_elctbl_chc_id
2763: from ben_elig_per_elctbl_chc
2764: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2768: from ben_enrt_rt ecr

2764: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2765: UNION all
2766: select ecr.enrt_rt_id,
2767: ecr.object_version_number
2768: from ben_enrt_rt ecr
2769: where enrt_bnft_id in
2770: (select enrt_bnft_id
2771: from ben_enrt_bnft
2772: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);