[Home] [Help]
1132: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1133: end;
1134:
1135: --
1136: -- DK Resolve For Table BEN_LER_F
1137: --
1138: procedure get_dk_frm_ler is
1139: --
1140: -- cursor to Fetch the DK for BEN_LER_F.LER_ID
1136: -- DK Resolve For Table BEN_LER_F
1137: --
1138: procedure get_dk_frm_ler is
1139: --
1140: -- cursor to Fetch the DK for BEN_LER_F.LER_ID
1141: --
1142: cursor csr_get_dk_ler (c_business_group_id number, c_source_key varchar2) is
1143: select ler_id
1144: from ben_ler_f
1140: -- cursor to Fetch the DK for BEN_LER_F.LER_ID
1141: --
1142: cursor csr_get_dk_ler (c_business_group_id number, c_source_key varchar2) is
1143: select ler_id
1144: from ben_ler_f
1145: where name = c_source_key
1146: and business_group_id = c_business_group_id;
1147:
1148: cursor csr_get_all_ler is
1147:
1148: cursor csr_get_all_ler is
1149: select *
1150: from ben_dm_resolve_mappings
1151: where table_name = 'BEN_LER_F'
1152: and target_id is null;
1153:
1154: -- Declare local variables
1155: l_proc varchar2(72) := g_package || 'get_dk_frm_ler';
1160:
1161: begin
1162:
1163: --
1164: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_LER_F
1165: --
1166: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1167: for x in csr_get_all_ler loop
1168: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3174:
3175: -- DK Resolve for Table BEN_CVG_AMT_CALC_MTHD_F
3176: get_dk_frm_ccm;
3177:
3178: -- DK Resolve for Table BEN_LER_F
3179: get_dk_frm_ler;
3180:
3181: -- DK Resolve for Table BEN_OPT_F
3182: get_dk_frm_opt;