eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_DOWNLOAD_DK dependencies on HR_LOCATIONS_ALL

Line 2225: -- DK Resolve from Table HR_LOCATIONS_ALL

2221: ,p_business_group_name => p_business_group_name);
2222: --
2223: end;
2224: --
2225: -- DK Resolve from Table HR_LOCATIONS_ALL
2226: --
2227: procedure get_dk_frm_loc (p_business_group_name in VARCHAR2
2228: ,p_source_id in NUMBER
2229: ,p_resolve_mapping_id out nocopy NUMBER) is

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

2227: procedure get_dk_frm_loc (p_business_group_name in VARCHAR2
2228: ,p_source_id in NUMBER
2229: ,p_resolve_mapping_id out nocopy NUMBER) is
2230: --
2231: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID
2232: --
2233: cursor csr_get_dk_loc is
2234: select location_code
2235: from hr_locations_all

Line 2235: from hr_locations_all

2231: -- cursor to Fetch the DK for HR_LOCATIONS_ALL.LOCATION_ID
2232: --
2233: cursor csr_get_dk_loc is
2234: select location_code
2235: from hr_locations_all
2236: where location_id = p_source_id;
2237:
2238: -- Declare local variables
2239: l_proc varchar2(72) := g_package || 'get_dk_frm_loc';

Line 2242: l_table_name varchar2(30) := 'HR_LOCATIONS_ALL';

2238: -- Declare local variables
2239: l_proc varchar2(72) := g_package || 'get_dk_frm_loc';
2240: l_row_fetched boolean := FALSE;
2241: l_table_rec csr_get_dk_loc%rowtype;
2242: l_table_name varchar2(30) := 'HR_LOCATIONS_ALL';
2243: l_column_name varchar2(30) := 'LOCATION_ID';
2244: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2245:
2246: begin