APPS.BEN_DM_UPLOAD_DK dependencies on HR_LOCATIONS_ALL

Line 2126: -- DK Resolve For Table HR_LOCATIONS_ALL

2122:
2123:
2124:
2125: --
2126: -- DK Resolve For Table HR_LOCATIONS_ALL
2127: --
2128: procedure get_dk_frm_loc is
2129: --
2130: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID

Line 2130: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID

2126: -- DK Resolve For Table HR_LOCATIONS_ALL
2127: --
2128: procedure get_dk_frm_loc is
2129: --
2130: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID
2131: --
2132: cursor csr_get_dk_loc (c_business_group_id number, c_source_key varchar2) is
2133: select location_id
2134: from hr_locations_all

Line 2134: from hr_locations_all

2130: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID
2131: --
2132: cursor csr_get_dk_loc (c_business_group_id number, c_source_key varchar2) is
2133: select location_id
2134: from hr_locations_all
2135: where location_code = c_source_key
2136: ;
2137:
2138: cursor csr_get_all_loc is

Line 2141: where table_name = 'HR_LOCATIONS_ALL'

2137:
2138: cursor csr_get_all_loc is
2139: select *
2140: from ben_dm_resolve_mappings
2141: where table_name = 'HR_LOCATIONS_ALL'
2142: and target_id is null;
2143:
2144: -- Declare local variables
2145: l_proc varchar2(72) := g_package || 'get_dk_frm_loc';

Line 2154: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_LOCATIONS_ALL

2150:
2151: begin
2152:
2153: --
2154: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_LOCATIONS_ALL
2155: --
2156: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2157: for x in csr_get_all_loc loop
2158: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3213: -- DK Resolve for Table HR_LOCATIONS_ALL

3209: get_dk_frm_aou;
3210:
3211: get_dk_frm_ori ;
3212:
3213: -- DK Resolve for Table HR_LOCATIONS_ALL
3214: get_dk_frm_loc;
3215:
3216: -- DK Resolve for Table PAY_ALL_PAYROLLS_F
3217: get_dk_frm_prl;