APPS.BEN_DM_DOWNLOAD_DK dependencies on HR_SOFT_CODING_KEYFLEX

Line 3049: -- DK Resolve from Table HR_SOFT_CODING_KEYFLEX

3045: end if;
3046: end;
3047: --
3048: --
3049: -- DK Resolve from Table HR_SOFT_CODING_KEYFLEX
3050: --
3051: procedure get_dk_frm_scl (p_business_group_name in VARCHAR2
3052: ,p_source_id in NUMBER
3053: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 3055: -- cursor to Fetch the DK for HR_SOFT_CODING_KEYFLEX

3051: procedure get_dk_frm_scl (p_business_group_name in VARCHAR2
3052: ,p_source_id in NUMBER
3053: ,p_resolve_mapping_id out nocopy NUMBER) is
3054: --
3055: -- cursor to Fetch the DK for HR_SOFT_CODING_KEYFLEX
3056: --
3057: cursor csr_get_dk_scl is
3058: select *
3059: from hr_soft_coding_keyflex

Line 3059: from hr_soft_coding_keyflex

3055: -- cursor to Fetch the DK for HR_SOFT_CODING_KEYFLEX
3056: --
3057: cursor csr_get_dk_scl is
3058: select *
3059: from hr_soft_coding_keyflex
3060: where soft_coding_keyflex_id = p_source_id;
3061:
3062: -- Declare local variables
3063: l_proc varchar2(72) := g_package || 'get_dk_frm_scl';

Line 3066: l_table_name varchar2(30) := 'HR_SOFT_CODING_KEYFLEX';

3062: -- Declare local variables
3063: l_proc varchar2(72) := g_package || 'get_dk_frm_scl';
3064: l_row_fetched boolean := FALSE;
3065: l_table_rec csr_get_dk_scl%rowtype;
3066: l_table_name varchar2(30) := 'HR_SOFT_CODING_KEYFLEX';
3067: l_column_name varchar2(30) := 'SOFT_CODING_KEYFLEX_ID';
3068: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
3069: l_migration_id number;
3070: l_result_id number;