[Home] [Help]
800: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
801: end;
802:
803: --
804: -- DK Resolve For Table BEN_COMP_LVL_FCTR
805: --
806: procedure get_dk_frm_clf is
807: --
808: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID
804: -- DK Resolve For Table BEN_COMP_LVL_FCTR
805: --
806: procedure get_dk_frm_clf is
807: --
808: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID
809: --
810: cursor csr_get_dk_clf (c_business_group_id number, c_source_key varchar2) is
811: select comp_lvl_fctr_id
812: from ben_comp_lvl_fctr
808: -- cursor to Fetch the DK for BEN_COMP_LVL_FCTR.COMP_LVL_FCTR_ID
809: --
810: cursor csr_get_dk_clf (c_business_group_id number, c_source_key varchar2) is
811: select comp_lvl_fctr_id
812: from ben_comp_lvl_fctr
813: where name = c_source_key
814: and business_group_id = c_business_group_id
815: ;
816:
816:
817: cursor csr_get_all_clf is
818: select *
819: from ben_dm_resolve_mappings
820: where table_name = 'BEN_COMP_LVL_FCTR'
821: and target_id is null;
822:
823: -- Declare local variables
824: l_proc varchar2(72) := g_package || 'get_dk_frm_clf';
829:
830: begin
831:
832: --
833: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_COMP_LVL_FCTR
834: --
835: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
836: for x in csr_get_all_clf loop
837: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3168:
3169: -- DK Resolve for Table BEN_CM_TYP_F
3170: get_dk_frm_cct;
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;