DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ENRT_PREM

Line 560: from ben_enrt_prem epr

556: v_enrt_bnft_id in number) is
557: select epr.val,
558: epr.enrt_prem_id,
559: epr.actl_prem_id
560: from ben_enrt_prem epr
561: where epr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
562: and epr.business_group_id = p_business_group_id
563: UNION
564: select epr.val,

Line 567: from ben_enrt_prem epr

563: UNION
564: select epr.val,
565: epr.enrt_prem_id,
566: epr.actl_prem_id
567: from ben_enrt_prem epr
568: where epr.enrt_bnft_id = v_enrt_bnft_id
569: and epr.business_group_id = p_business_group_id;
570: --
571: cursor c_ppe(v_actl_prem_id number