APPS.BEN_DM_DOWNLOAD_DK dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2128: -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS

2124: --
2125: end if;
2126: end;
2127: --
2128: -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS
2129: --
2130: procedure get_dk_frm_aou (p_business_group_name in VARCHAR2
2131: ,p_source_id in NUMBER
2132: ,p_resolve_mapping_id out nocopy NUMBER) is

Line 2134: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID

2130: procedure get_dk_frm_aou (p_business_group_name in VARCHAR2
2131: ,p_source_id in NUMBER
2132: ,p_resolve_mapping_id out nocopy NUMBER) is
2133: --
2134: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID
2135: --
2136: cursor csr_get_dk_aou is
2137: select name, business_group_id
2138: from hr_all_organization_units

Line 2138: from hr_all_organization_units

2134: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID
2135: --
2136: cursor csr_get_dk_aou is
2137: select name, business_group_id
2138: from hr_all_organization_units
2139: where organization_id = p_source_id;
2140:
2141: -- Declare local variables
2142: l_proc varchar2(72) := g_package || 'get_dk_frm_aou';

Line 2145: l_table_name varchar2(30) := 'HR_ALL_ORGANIZATION_UNITS';

2141: -- Declare local variables
2142: l_proc varchar2(72) := g_package || 'get_dk_frm_aou';
2143: l_row_fetched boolean := FALSE;
2144: l_table_rec csr_get_dk_aou%rowtype;
2145: l_table_name varchar2(30) := 'HR_ALL_ORGANIZATION_UNITS';
2146: l_column_name varchar2(30) := 'ORGANIZATION_ID';
2147: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2148: begin
2149:

Line 2198: -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS - FOR BG ONLY

2194: --
2195: end if;
2196: end;
2197: --
2198: -- DK Resolve from Table HR_ALL_ORGANIZATION_UNITS - FOR BG ONLY
2199: -- Special
2200: procedure get_dk_frm_ori (p_business_group_name in VARCHAR2
2201: ,p_source_id in NUMBER
2202: ,p_resolve_mapping_id out nocopy NUMBER) is