[Home] [Help]
485: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
486: end;
487:
488: --
489: -- DK Resolve For Table BEN_CMBN_PLIP_F
490: --
491: procedure get_dk_frm_cpl is
492: --
493: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID
489: -- DK Resolve For Table BEN_CMBN_PLIP_F
490: --
491: procedure get_dk_frm_cpl is
492: --
493: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID
494: --
495: cursor csr_get_dk_cpl (c_business_group_id number, c_source_key varchar2) is
496: select cmbn_plip_id
497: from ben_cmbn_plip_f
493: -- cursor to Fetch the DK for BEN_CMBN_PLIP_F.CMBN_PLIP_ID
494: --
495: cursor csr_get_dk_cpl (c_business_group_id number, c_source_key varchar2) is
496: select cmbn_plip_id
497: from ben_cmbn_plip_f
498: where name = c_source_key
499: and business_group_id = c_business_group_id;
500:
501: cursor csr_get_all_cpl is
500:
501: cursor csr_get_all_cpl is
502: select *
503: from ben_dm_resolve_mappings
504: where table_name = 'BEN_CMBN_PLIP_F'
505: and target_id is null;
506:
507: -- Declare local variables
508: l_proc varchar2(72) := g_package || 'get_dk_frm_cpl';
513:
514: begin
515:
516: --
517: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PLIP_F
518: --
519: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
520: for x in csr_get_all_cpl loop
521: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
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;
3159:
3160: -- DK Resolve for Table BEN_CMBN_PTIP_F
3161: get_dk_frm_cbp;