APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ENRT_RT

Line 1083: from ben_enrt_rt ecr

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

Line 1093: from ben_enrt_rt ecr

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

Line 1114: from ben_enrt_rt ecr,

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

Line 1124: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

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

Line 1125: dflt_val ben_enrt_rt.dflt_val%type,

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

Line 1126: prtt_rt_val_id ben_enrt_rt.prtt_rt_val_id%type,

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

Line 1127: ann_rt_val ben_enrt_rt.ann_val%type);

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