[Home] [Help]
548: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
549: end;
550:
551: --
552: -- DK Resolve For Table BEN_CMBN_PTIP_F
553: --
554: procedure get_dk_frm_cbp is
555: --
556: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID
552: -- DK Resolve For Table BEN_CMBN_PTIP_F
553: --
554: procedure get_dk_frm_cbp is
555: --
556: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID
557: --
558: cursor csr_get_dk_cbp (c_business_group_id number, c_source_key varchar2) is
559: select cmbn_ptip_id
560: from ben_cmbn_ptip_f
556: -- cursor to Fetch the DK for BEN_CMBN_PTIP_F.CMBN_PTIP_ID
557: --
558: cursor csr_get_dk_cbp (c_business_group_id number, c_source_key varchar2) is
559: select cmbn_ptip_id
560: from ben_cmbn_ptip_f
561: where name = c_source_key
562: and business_group_id = c_business_group_id;
563:
564: cursor csr_get_all_cbp is
563:
564: cursor csr_get_all_cbp is
565: select *
566: from ben_dm_resolve_mappings
567: where table_name = 'BEN_CMBN_PTIP_F'
568: and target_id is null;
569:
570: -- Declare local variables
571: l_proc varchar2(72) := g_package || 'get_dk_frm_cbp';
576:
577: begin
578:
579: --
580: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PTIP_F
581: --
582: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
583: for x in csr_get_all_cbp loop
584: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
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;
3162:
3163: -- DK Resolve for Table BEN_CMBN_PTIP_OPT_F
3164: get_dk_frm_cpt;