[Home] [Help]
611: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
612: end;
613:
614: --
615: -- DK Resolve For Table BEN_CMBN_PTIP_OPT_F
616: --
617: procedure get_dk_frm_cpt is
618: --
619: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID
615: -- DK Resolve For Table BEN_CMBN_PTIP_OPT_F
616: --
617: procedure get_dk_frm_cpt is
618: --
619: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID
620: --
621: cursor csr_get_dk_cpt (c_business_group_id number, c_source_key varchar2) is
622: select cmbn_ptip_opt_id
623: from ben_cmbn_ptip_opt_f
619: -- cursor to Fetch the DK for BEN_CMBN_PTIP_OPT_F.CMBN_PTIP_OPT_ID
620: --
621: cursor csr_get_dk_cpt (c_business_group_id number, c_source_key varchar2) is
622: select cmbn_ptip_opt_id
623: from ben_cmbn_ptip_opt_f
624: where name = c_source_key
625: and business_group_id = c_business_group_id;
626:
627: cursor csr_get_all_cpt is
626:
627: cursor csr_get_all_cpt is
628: select *
629: from ben_dm_resolve_mappings
630: where table_name = 'BEN_CMBN_PTIP_OPT_F'
631: and target_id is null;
632:
633: -- Declare local variables
634: l_proc varchar2(72) := g_package || 'get_dk_frm_cpt';
639:
640: begin
641:
642: --
643: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PTIP_OPT_F
644: --
645: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
646: for x in csr_get_all_cpt loop
647: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
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;
3165:
3166: -- DK Resolve for Table BEN_CM_TRGR
3167: get_dk_frm_bcr;