DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_ENRT_PREM

Line 608: from ben_enrt_prem epr

604: v_enrt_bnft_id in number) is
605: select epr.val,
606: epr.enrt_prem_id,
607: epr.actl_prem_id
608: from ben_enrt_prem epr
609: where epr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
610: and epr.business_group_id = p_business_group_id
611: UNION
612: select epr.val,

Line 615: from ben_enrt_prem epr

611: UNION
612: select epr.val,
613: epr.enrt_prem_id,
614: epr.actl_prem_id
615: from ben_enrt_prem epr
616: where epr.enrt_bnft_id = v_enrt_bnft_id
617: and epr.business_group_id = p_business_group_id;
618: --
619: cursor c_ppe(v_actl_prem_id number