422: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
423: end;
424:
425: --
426: -- DK Resolve For Table BEN_BNFT_PRVDR_POOL_F
427: --
428: procedure get_dk_frm_bpp is
429: --
430: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID
426: -- DK Resolve For Table BEN_BNFT_PRVDR_POOL_F
427: --
428: procedure get_dk_frm_bpp is
429: --
430: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID
431: --
432: cursor csr_get_dk_bpp (c_business_group_id number, c_source_key varchar2) is
433: select bnft_prvdr_pool_id
434: from ben_bnft_prvdr_pool_f
430: -- cursor to Fetch the DK for BEN_BNFT_PRVDR_POOL_F.BNFT_PRVDR_POOL_ID
431: --
432: cursor csr_get_dk_bpp (c_business_group_id number, c_source_key varchar2) is
433: select bnft_prvdr_pool_id
434: from ben_bnft_prvdr_pool_f
435: where name = c_source_key
436: and business_group_id = c_business_group_id;
437:
438: cursor csr_get_all_bpp is
437:
438: cursor csr_get_all_bpp is
439: select *
440: from ben_dm_resolve_mappings
441: where table_name = 'BEN_BNFT_PRVDR_POOL_F'
442: and target_id is null;
443:
444: -- Declare local variables
445: l_proc varchar2(72) := g_package || 'get_dk_frm_bpp';
450:
451: begin
452:
453: --
454: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BNFT_PRVDR_POOL_F
455: --
456: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
457: for x in csr_get_all_bpp loop
458: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3150:
3151: -- DK Resolve for Table BEN_BNFTS_BAL_F
3152: get_dk_frm_bnb;
3153:
3154: -- DK Resolve for Table BEN_BNFT_PRVDR_POOL_F
3155: get_dk_frm_bpp;
3156:
3157: -- DK Resolve for Table BEN_CMBN_PLIP_F
3158: get_dk_frm_cpl;