[Home] [Help]
1266: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1267: end;
1268:
1269: --
1270: -- DK Resolve For Table BEN_OIPL_F
1271: --
1272: procedure get_dk_frm_cop is
1273: --
1274: -- cursor to Fetch the DK for BEN_OIPL_F.OIPL_ID
1270: -- DK Resolve For Table BEN_OIPL_F
1271: --
1272: procedure get_dk_frm_cop is
1273: --
1274: -- cursor to Fetch the DK for BEN_OIPL_F.OIPL_ID
1275: --
1276: cursor csr_get_dk_cop (c_business_group_id number, c_source_key varchar2
1277: ,c_target_id1 number, c_target_id2 number) is
1278: select oipl_id
1275: --
1276: cursor csr_get_dk_cop (c_business_group_id number, c_source_key varchar2
1277: ,c_target_id1 number, c_target_id2 number) is
1278: select oipl_id
1279: from ben_oipl_f
1280: where pl_id = c_target_id1
1281: and opt_id = c_target_id2
1282: and business_group_id = c_business_group_id;
1283:
1283:
1284: cursor csr_get_all_cop is
1285: select *
1286: from ben_dm_resolve_mappings
1287: where table_name = 'BEN_OIPL_F'
1288: and target_id is null;
1289:
1290: -- Declare local variables
1291: l_proc varchar2(72) := g_package || 'get_dk_frm_cop';
1298:
1299: begin
1300:
1301: --
1302: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OIPL_F
1303: --
1304: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1305: for x in csr_get_all_cop loop
1306: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3248:
3249: -- DK Resolve for Table BEN_ENRT_PERD
3250: get_dk_frm_enp;
3251:
3252: -- DK Resolve for Table BEN_OIPL_F
3253: get_dk_frm_cop;
3254:
3255: -- DK Resolve for Table BEN_PLIP_F
3256: get_dk_frm_cpp;