APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ENRT_RT

Line 1081: from ben_enrt_rt ecr

1077: select ecr.enrt_rt_id,
1078: nvl(ecr.val,ecr.dflt_val) default_value,
1079: nvl(ecr.ann_dflt_val,ecr.ann_val) ann_rt_val,
1080: ecr.prtt_rt_val_id
1081: from ben_enrt_rt ecr
1082: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
1083: and ecr.business_group_id = p_business_group_id
1084: and ecr.entr_val_at_enrt_flag = 'Y'
1085: and ecr.spcl_rt_enrt_rt_id is null

Line 1091: from ben_enrt_rt ecr

1087: select ecr.enrt_rt_id,
1088: nvl(ecr.val,ecr.dflt_val) default_value,
1089: nvl(ecr.ann_dflt_val,ecr.ann_val) ann_rt_val,
1090: ecr.prtt_rt_val_id
1091: from ben_enrt_rt ecr
1092: where ecr.enrt_bnft_id = v_enrt_bnft_id
1093: and ecr.business_group_id = p_business_group_id
1094: and ecr.entr_val_at_enrt_flag = 'Y'
1095: and ecr.spcl_rt_enrt_rt_id is null

Line 1112: from ben_enrt_rt ecr,

1108: select ecr.rt_strt_dt,
1109: ecr.rt_strt_dt_cd,
1110: ecr.rt_strt_dt_rl,
1111: nvl(ecr.elig_per_elctbl_chc_id,enb.elig_per_elctbl_chc_id) elig_per_elctbl_chc_id
1112: from ben_enrt_rt ecr,
1113: ben_enrt_bnft enb
1114: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
1115: and ecr.enrt_bnft_id = enb.enrt_bnft_id (+) ;
1116: --

Line 1122: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

1118: --
1119: l_cvg_strt_dt date;
1120:
1121: type g_rt_rec is record
1122: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
1123: dflt_val ben_enrt_rt.dflt_val%type,
1124: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
1125: ann_rt_val ben_enrt_rt.ann_val%type);
1126: --

Line 1123: dflt_val ben_enrt_rt.dflt_val%type,

1119: l_cvg_strt_dt date;
1120:
1121: type g_rt_rec is record
1122: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
1123: dflt_val ben_enrt_rt.dflt_val%type,
1124: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
1125: ann_rt_val ben_enrt_rt.ann_val%type);
1126: --
1127: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 1124: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,

1120:
1121: type g_rt_rec is record
1122: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
1123: dflt_val ben_enrt_rt.dflt_val%type,
1124: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
1125: ann_rt_val ben_enrt_rt.ann_val%type);
1126: --
1127: type g_rt_table is table of g_rt_rec index by binary_integer;
1128: --

Line 1125: ann_rt_val ben_enrt_rt.ann_val%type);

1121: type g_rt_rec is record
1122: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
1123: dflt_val ben_enrt_rt.dflt_val%type,
1124: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,
1125: ann_rt_val ben_enrt_rt.ann_val%type);
1126: --
1127: type g_rt_table is table of g_rt_rec index by binary_integer;
1128: --
1129: l_rt_table g_rt_table;