APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CM_TRGR

Line 656: -- DK Resolve from Table BEN_CM_TRGR

652: --
653: end if;
654: end;
655: --
656: -- DK Resolve from Table BEN_CM_TRGR
657: --
658: procedure get_dk_frm_bcr (p_business_group_name in VARCHAR2
659: ,p_source_id in NUMBER
660: ,p_resolve_mapping_id out nocopy NUMBER) is

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

658: procedure get_dk_frm_bcr (p_business_group_name in VARCHAR2
659: ,p_source_id in NUMBER
660: ,p_resolve_mapping_id out nocopy NUMBER) is
661: --
662: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID
663: --
664: cursor csr_get_dk_bcr is
665: select cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd name
666: from ben_cm_trgr

Line 666: from ben_cm_trgr

662: -- cursor to Fetch the DK for BEN_CM_TRGR.CM_TRGR_ID
663: --
664: cursor csr_get_dk_bcr is
665: select cm_trgr_src_cd||cm_trgr_typ_cd||proc_cd name
666: from ben_cm_trgr
667: where cm_trgr_id = p_source_id;
668:
669: -- Declare local variables
670: l_proc varchar2(72) := g_package || 'get_dk_frm_bcr';

Line 673: l_table_name varchar2(30) := 'BEN_CM_TRGR';

669: -- Declare local variables
670: l_proc varchar2(72) := g_package || 'get_dk_frm_bcr';
671: l_row_fetched boolean := FALSE;
672: l_table_rec csr_get_dk_bcr%rowtype;
673: l_table_name varchar2(30) := 'BEN_CM_TRGR';
674: l_column_name varchar2(30) := 'CM_TRGR_ID';
675: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
676:
677: begin