APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_ENRT_RT

Line 689: from ben_enrt_rt ecr

685: select ecr.enrt_rt_id,
686: nvl(ecr.val,ecr.dflt_val) default_value,
687: nvl(ecr.ann_dflt_val,ecr.ann_val) ann_rt_val,
688: ecr.prtt_rt_val_id
689: from ben_enrt_rt ecr
690: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
691: and ecr.business_group_id = p_business_group_id
692: and ecr.entr_val_at_enrt_flag = 'Y'
693: and ecr.spcl_rt_enrt_rt_id is null

Line 699: from ben_enrt_rt ecr

695: select ecr.enrt_rt_id,
696: nvl(ecr.val,ecr.dflt_val) default_value,
697: nvl(ecr.ann_dflt_val,ecr.ann_val) ann_rt_val,
698: ecr.prtt_rt_val_id
699: from ben_enrt_rt ecr
700: where ecr.enrt_bnft_id = v_enrt_bnft_id
701: and ecr.business_group_id = p_business_group_id
702: and ecr.entr_val_at_enrt_flag = 'Y'
703: and ecr.spcl_rt_enrt_rt_id is null

Line 711: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

707: --
708: l_cvg_strt_dt date;
709:
710: type g_rt_rec is record
711: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
712: dflt_val ben_enrt_rt.dflt_val%type,
713: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
714: ann_rt_val ben_enrt_rt.ann_val%type);
715: --

Line 712: dflt_val ben_enrt_rt.dflt_val%type,

708: l_cvg_strt_dt date;
709:
710: type g_rt_rec is record
711: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
712: dflt_val ben_enrt_rt.dflt_val%type,
713: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
714: ann_rt_val ben_enrt_rt.ann_val%type);
715: --
716: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 713: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,

709:
710: type g_rt_rec is record
711: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
712: dflt_val ben_enrt_rt.dflt_val%type,
713: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
714: ann_rt_val ben_enrt_rt.ann_val%type);
715: --
716: type g_rt_table is table of g_rt_rec index by binary_integer;
717: --

Line 714: ann_rt_val ben_enrt_rt.ann_val%type);

710: type g_rt_rec is record
711: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
712: dflt_val ben_enrt_rt.dflt_val%type,
713: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
714: ann_rt_val ben_enrt_rt.ann_val%type);
715: --
716: type g_rt_table is table of g_rt_rec index by binary_integer;
717: --
718: l_rt_table g_rt_table;