APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_ENRT_RT

Line 2752: from ben_enrt_rt ecr

2748:
2749: cursor c_rate is
2750: /* select ecr.enrt_rt_id,
2751: ecr.object_version_number
2752: from ben_enrt_rt ecr
2753: where elig_per_elctbl_chc_id in
2754: (select elig_per_elctbl_chc_id
2755: from ben_elig_per_elctbl_chc
2756: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2765: from ben_enrt_rt ecr

2761: */
2762:
2763: select ecr.enrt_rt_id,
2764: ecr.object_version_number
2765: from ben_enrt_rt ecr
2766: where elig_per_elctbl_chc_id in
2767: (select elig_per_elctbl_chc_id
2768: from ben_elig_per_elctbl_chc
2769: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)

Line 2773: from ben_enrt_rt ecr

2769: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2770: UNION all
2771: select ecr.enrt_rt_id,
2772: ecr.object_version_number
2773: from ben_enrt_rt ecr
2774: where enrt_bnft_id in
2775: (select enrt_bnft_id
2776: from ben_enrt_bnft
2777: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);