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_UPLOAD_DK dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1993: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS

1989: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1990: end;
1991:
1992: --
1993: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS
1994: --
1995: procedure get_dk_frm_aou is
1996: --
1997: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID

Line 1997: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID

1993: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS
1994: --
1995: procedure get_dk_frm_aou is
1996: --
1997: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID
1998: --
1999: cursor csr_get_dk_aou (c_business_group_id number, c_source_key varchar2) is
2000: select organization_id
2001: from hr_all_organization_units

Line 2001: from hr_all_organization_units

1997: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID
1998: --
1999: cursor csr_get_dk_aou (c_business_group_id number, c_source_key varchar2) is
2000: select organization_id
2001: from hr_all_organization_units
2002: where name = c_source_key
2003: and business_group_id = c_business_group_id;
2004:
2005: cursor csr_get_all_aou is

Line 2008: where table_name = 'HR_ALL_ORGANIZATION_UNITS'

2004:
2005: cursor csr_get_all_aou is
2006: select *
2007: from ben_dm_resolve_mappings
2008: where table_name = 'HR_ALL_ORGANIZATION_UNITS'
2009: and target_id is null;
2010:
2011: -- Declare local variables
2012: l_proc varchar2(72) := g_package || 'get_dk_frm_aou';

Line 2021: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS

2017:
2018: begin
2019:
2020: --
2021: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS
2022: --
2023: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2024: for x in csr_get_all_aou loop
2025: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 2058: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS

2054:
2055:
2056:
2057:
2058: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS
2059: -- for business greoup
2060: --
2061: procedure get_dk_frm_ori is
2062: --

Line 2063: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID

2059: -- for business greoup
2060: --
2061: procedure get_dk_frm_ori is
2062: --
2063: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID
2064: --
2065: cursor csr_get_dk_ori (c_business_group_id number, c_source_key varchar2) is
2066: select organization_id
2067: from hr_all_organization_units

Line 2067: from hr_all_organization_units

2063: -- cursor to Fetch the DK for HR_ALL_ORGANIZATION_UNITS.PERSON_ID
2064: --
2065: cursor csr_get_dk_ori (c_business_group_id number, c_source_key varchar2) is
2066: select organization_id
2067: from hr_all_organization_units
2068: where name = c_source_key
2069: and business_group_id = c_business_group_id;
2070:
2071: cursor csr_get_all_ori is

Line 2088: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS

2084:
2085: begin
2086:
2087: --
2088: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS
2089: --
2090: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2091: for x in csr_get_all_ori loop
2092: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

Line 3208: -- DK Resolve for Table HR_ALL_ORGANIZATION_UNITS

3204:
3205: -- DK Resolve for Table FND_USER
3206: get_dk_frm_fus;
3207:
3208: -- DK Resolve for Table HR_ALL_ORGANIZATION_UNITS
3209: get_dk_frm_aou;
3210:
3211: get_dk_frm_ori ;
3212: