[Home] [Help]
864: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
865: end;
866:
867: --
868: -- DK Resolve For Table BEN_CVG_AMT_CALC_MTHD_F
869: --
870: procedure get_dk_frm_ccm is
871: --
872: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID
868: -- DK Resolve For Table BEN_CVG_AMT_CALC_MTHD_F
869: --
870: procedure get_dk_frm_ccm is
871: --
872: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID
873: --
874: cursor csr_get_dk_ccm (c_business_group_id number, c_source_key varchar2) is
875: select cvg_amt_calc_mthd_id
876: from ben_cvg_amt_calc_mthd_f
872: -- cursor to Fetch the DK for BEN_CVG_AMT_CALC_MTHD_F.CVG_AMT_CALC_MTHD_ID
873: --
874: cursor csr_get_dk_ccm (c_business_group_id number, c_source_key varchar2) is
875: select cvg_amt_calc_mthd_id
876: from ben_cvg_amt_calc_mthd_f
877: where name = c_source_key
878: and business_group_id = c_business_group_id;
879:
880: cursor csr_get_all_ccm is
879:
880: cursor csr_get_all_ccm is
881: select *
882: from ben_dm_resolve_mappings
883: where table_name = 'BEN_CVG_AMT_CALC_MTHD_F'
884: and target_id is null;
885:
886: -- Declare local variables
887: l_proc varchar2(72) := g_package || 'get_dk_frm_ccm';
892:
893: begin
894:
895: --
896: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CVG_AMT_CALC_MTHD_F
897: --
898: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
899: for x in csr_get_all_ccm loop
900: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3171:
3172: -- DK Resolve for Table BEN_COMP_LVL_FCTR
3173: get_dk_frm_clf;
3174:
3175: -- DK Resolve for Table BEN_CVG_AMT_CALC_MTHD_F
3176: get_dk_frm_ccm;
3177:
3178: -- DK Resolve for Table BEN_LER_F
3179: get_dk_frm_ler;