APPS.BEN_DM_DOWNLOAD_DK dependencies on FND_USER

Line 2063: -- DK Resolve from Table FND_USER

2059: --
2060: end if;
2061: end;
2062: --
2063: -- DK Resolve from Table FND_USER
2064: --
2065: procedure get_dk_frm_fus (p_business_group_name in VARCHAR2
2066: ,p_source_id in NUMBER
2067: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2069: -- cursor to Fetch the DK for FND_USER.USER_ID

2065: procedure get_dk_frm_fus (p_business_group_name in VARCHAR2
2066: ,p_source_id in NUMBER
2067: ,p_resolve_mapping_id out nocopy NUMBER) is
2068: --
2069: -- cursor to Fetch the DK for FND_USER.USER_ID
2070: --
2071: cursor csr_get_dk_fus is
2072: select user_name
2073: from fnd_user

Line 2073: from fnd_user

2069: -- cursor to Fetch the DK for FND_USER.USER_ID
2070: --
2071: cursor csr_get_dk_fus is
2072: select user_name
2073: from fnd_user
2074: where user_id = p_source_id;
2075:
2076: -- Declare local variables
2077: l_proc varchar2(72) := g_package || 'get_dk_frm_fus';

Line 2080: l_table_name varchar2(30) := 'FND_USER';

2076: -- Declare local variables
2077: l_proc varchar2(72) := g_package || 'get_dk_frm_fus';
2078: l_row_fetched boolean := FALSE;
2079: l_table_rec csr_get_dk_fus%rowtype;
2080: l_table_name varchar2(30) := 'FND_USER';
2081: l_column_name varchar2(30) := 'USER_ID';
2082: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2083:
2084: begin