APPS.BEN_DM_UPLOAD_DK dependencies on BEN_CM_TRGR

Line 678: -- DK Resolve For Table BEN_CM_TRGR

674: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
675: end;
676:
677: --
678: -- DK Resolve For Table BEN_CM_TRGR
679: --
680: procedure get_dk_frm_bcr is
681: --
682: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID

Line 682: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID

678: -- DK Resolve For Table BEN_CM_TRGR
679: --
680: procedure get_dk_frm_bcr is
681: --
682: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID
683: --
684: cursor csr_get_dk_bcr (c_business_group_id number, c_source_key varchar2) is
685: select cm_trgr_id
686: from ben_cm_trgr

Line 686: from ben_cm_trgr

682: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID
683: --
684: cursor csr_get_dk_bcr (c_business_group_id number, c_source_key varchar2) is
685: select cm_trgr_id
686: from ben_cm_trgr
687: where cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd = c_source_key
688: ;
689:
690: cursor csr_get_all_bcr is

Line 693: where table_name = 'BEN_CM_TRGR'

689:
690: cursor csr_get_all_bcr is
691: select *
692: from ben_dm_resolve_mappings
693: where table_name = 'BEN_CM_TRGR'
694: and target_id is null;
695:
696: -- Declare local variables
697: l_proc varchar2(72) := g_package || 'get_dk_frm_bcr';

Line 706: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TRGR

702:
703: begin
704:
705: --
706: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TRGR
707: --
708: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
709: for x in csr_get_all_bcr loop
710: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3166: -- DK Resolve for Table BEN_CM_TRGR

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;
3168:
3169: -- DK Resolve for Table BEN_CM_TYP_F
3170: get_dk_frm_cct;