APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ENRT_BNFT

Line 302: select null from ben_enrt_rt ecr, ben_enrt_bnft enb

298: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
299: and (exists (select null from ben_enrt_rt ecr
300: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
301: and ecr.rt_mlt_cd = 'ERL') or exists (
302: select null from ben_enrt_rt ecr, ben_enrt_bnft enb
303: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
304: and ecr.enrt_bnft_id = enb.enrt_bnft_id
305: and ecr.rt_mlt_cd = 'ERL'));
306:

Line 325: and (exists (select null from ben_enrt_bnft enb

321: where epe.per_in_ler_id = l_per_in_ler_id
322: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
323: and epe.per_in_ler_id = pel.per_in_ler_id
324: and epe.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
325: and (exists (select null from ben_enrt_bnft enb
326: where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
327: and enb.cvg_mlt_cd = 'ERL')
328: );
329: --

Line 416: from ben_enrt_bnft enb

412: enb.enrt_bnft_id,
413: enb.prtt_enrt_rslt_id,
414: enb.entr_val_at_enrt_flag,
415: enb.CVG_MLT_CD
416: from ben_enrt_bnft enb
417: where enb.elig_per_elctbl_chc_id = l_epe.elig_per_elctbl_chc_id
418: and ( enb.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id OR
419: (enb.prtt_enrt_rslt_id is null /* Bug 4715688 */
420: and enb.cvg_mlt_cd not like '%RNG')--bug#4938930