[Home] [Help]
162: end loop;
163: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
164: end;
165: --
166: -- DK Resolve For Table BEN_ACTY_BASE_RT_F
167: --
168: procedure get_dk_frm_abr is
169: --
170: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID
166: -- DK Resolve For Table BEN_ACTY_BASE_RT_F
167: --
168: procedure get_dk_frm_abr is
169: --
170: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID
171: --
172: cursor csr_get_dk_abr (c_business_group_id number, c_source_key varchar2) is
173: select acty_base_rt_id
174: from ben_acty_base_rt_f
170: -- cursor to Fetch the DK for BEN_ACTY_BASE_RT_F.ACTY_BASE_RT_ID
171: --
172: cursor csr_get_dk_abr (c_business_group_id number, c_source_key varchar2) is
173: select acty_base_rt_id
174: from ben_acty_base_rt_f
175: where name = c_source_key
176: and business_group_id = c_business_group_id;
177:
178: cursor csr_get_all_abr is
177:
178: cursor csr_get_all_abr is
179: select *
180: from ben_dm_resolve_mappings
181: where table_name = 'BEN_ACTY_BASE_RT_F'
182: and target_id is null;
183:
184: -- Declare local variables
185: l_proc varchar2(72) := g_package || 'get_dk_frm_abr';
190:
191: begin
192:
193: --
194: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTY_BASE_RT_F
195: --
196: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
197: for x in csr_get_all_abr loop
198: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3141:
3142: -- DK Resolve for Table BEN_ACTN_TYP
3143: get_dk_frm_eat;
3144:
3145: -- DK Resolve for Table BEN_ACTY_BASE_RT_F
3146: get_dk_frm_abr;
3147:
3148: -- DK Resolve for Table BEN_BENFTS_GRP
3149: get_dk_frm_bng;