APPS.BEN_DM_DOWNLOAD_DK dependencies on BEN_CM_TYP_F

Line 721: -- DK Resolve from Table BEN_CM_TYP_F

717: --
718: end if;
719: end;
720: --
721: -- DK Resolve from Table BEN_CM_TYP_F
722: --
723: procedure get_dk_frm_cct (p_business_group_name in VARCHAR2
724: ,p_source_id in NUMBER
725: ,p_resolve_mapping_id out nocopy NUMBER) is

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

723: procedure get_dk_frm_cct (p_business_group_name in VARCHAR2
724: ,p_source_id in NUMBER
725: ,p_resolve_mapping_id out nocopy NUMBER) is
726: --
727: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID
728: --
729: cursor csr_get_dk_cct is
730: select name
731: from ben_cm_typ_f

Line 731: from ben_cm_typ_f

727: -- cursor to Fetch the DK for BEN_CM_TYP_F.CM_TYP_ID
728: --
729: cursor csr_get_dk_cct is
730: select name
731: from ben_cm_typ_f
732: where cm_typ_id = p_source_id;
733:
734: -- Declare local variables
735: l_proc varchar2(72) := g_package || 'get_dk_frm_cct';

Line 738: l_table_name varchar2(30) := 'BEN_CM_TYP_F';

734: -- Declare local variables
735: l_proc varchar2(72) := g_package || 'get_dk_frm_cct';
736: l_row_fetched boolean := FALSE;
737: l_table_rec csr_get_dk_cct%rowtype;
738: l_table_name varchar2(30) := 'BEN_CM_TYP_F';
739: l_column_name varchar2(30) := 'CM_TYP_ID';
740: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
741:
742: begin