APPS.BEN_DM_UPLOAD_DK dependencies on BEN_CM_TYP_F

Line 741: -- DK Resolve For Table BEN_CM_TYP_F

737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
738: end;
739:
740: --
741: -- DK Resolve For Table BEN_CM_TYP_F
742: --
743: procedure get_dk_frm_cct is
744: --
745: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID

Line 745: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID

741: -- DK Resolve For Table BEN_CM_TYP_F
742: --
743: procedure get_dk_frm_cct is
744: --
745: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID
746: --
747: cursor csr_get_dk_cct (c_business_group_id number, c_source_key varchar2) is
748: select cm_typ_id
749: from ben_cm_typ_f

Line 749: from ben_cm_typ_f

745: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID
746: --
747: cursor csr_get_dk_cct (c_business_group_id number, c_source_key varchar2) is
748: select cm_typ_id
749: from ben_cm_typ_f
750: where name = c_source_key
751: and business_group_id = c_business_group_id;
752:
753: cursor csr_get_all_cct is

Line 756: where table_name = 'BEN_CM_TYP_F'

752:
753: cursor csr_get_all_cct is
754: select *
755: from ben_dm_resolve_mappings
756: where table_name = 'BEN_CM_TYP_F'
757: and target_id is null;
758:
759: -- Declare local variables
760: l_proc varchar2(72) := g_package || 'get_dk_frm_cct';

Line 769: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TYP_F

765:
766: begin
767:
768: --
769: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TYP_F
770: --
771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
772: for x in csr_get_all_cct loop
773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3169: -- DK Resolve for Table BEN_CM_TYP_F

3165:
3166: -- DK Resolve for Table BEN_CM_TRGR
3167: get_dk_frm_bcr;
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;