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.PER_EEO_MAG_REPORT dependencies on HR_LOCATION_EXTRA_INFO

Line 1877: hr_location_extra_info hlei1,

1873: hlei2.lei_information4 naics_21,
1874: pghn.hierarchy_node_id,
1875: hlei2.lei_information10 hq
1876: FROM per_gen_hierarchy_nodes pghn,
1877: hr_location_extra_info hlei1,
1878: hr_location_extra_info hlei2,
1879: hr_locations_all eloc
1880: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1881: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus

Line 1878: hr_location_extra_info hlei2,

1874: pghn.hierarchy_node_id,
1875: hlei2.lei_information10 hq
1876: FROM per_gen_hierarchy_nodes pghn,
1877: hr_location_extra_info hlei1,
1878: hr_location_extra_info hlei2,
1879: hr_locations_all eloc
1880: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1881: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus
1882: -- pghn.hierarchy_version_id = 2823 -- Vik SD Albuquereque

Line 2206: FROM hr_location_extra_info lei

2202: ,lei_information13 p_ifemale
2203: ,lei_information17 p_tmracesfemale
2204: ,lei_information3 p_total
2205:
2206: FROM hr_location_extra_info lei
2207: ,per_gen_hierarchy_nodes pgn
2208: WHERE lei.lei_information1 = l_prev_year_filed
2209: AND lei.information_type = 'EEO-1 Archive Information'
2210: -- BUG3646445

Line 2257: FROM hr_location_extra_info

2253: SELECT 'U',
2254: location_extra_info_id
2255: INTO p_update,
2256: l_location_extra_info_id
2257: FROM hr_location_extra_info
2258: WHERE lei_information1 = p_report_year
2259: AND lei_information_category = 'EEO-1 Archive Information'
2260: AND location_id = l_location_id;
2261: EXCEPTION

Line 2288: FROM hr_location_extra_info

2284:
2285: BEGIN--Local3
2286: SELECT object_version_number
2287: INTO l_object_version_number
2288: FROM hr_location_extra_info
2289: WHERE location_extra_info_id = l_location_extra_info_id;
2290: END;--Local3
2291:
2292: BEGIN --Local4

Line 2293: hr_location_extra_info_api.delete_location_extra_info

2289: WHERE location_extra_info_id = l_location_extra_info_id;
2290: END;--Local3
2291:
2292: BEGIN --Local4
2293: hr_location_extra_info_api.delete_location_extra_info
2294: (p_validate => false -- true
2295: ,p_location_extra_info_id => l_location_extra_info_id
2296: ,p_object_version_number => l_object_version_number
2297: );

Line 2314: hr_location_extra_info_api.create_location_extra_info

2310: (which => fnd_file.log,
2311: buff => 'need to create new eit');
2312:
2313: BEGIN--Local5
2314: hr_location_extra_info_api.create_location_extra_info
2315: (p_validate => false -- true
2316: ,p_location_id => l_location_id
2317: ,p_information_type => 'EEO-1 Archive Information'
2318: ,p_lei_information_category => 'EEO-1 Archive Information'

Line 2365: FROM hr_location_extra_info lei

2361: BEGIN--Local7
2362:
2363: SELECT count(*)
2364: INTO l_eit_count
2365: FROM hr_location_extra_info lei
2366: WHERE location_id = l_location_id
2367: AND information_type = 'EEO-1 Archive Information';
2368: EXCEPTION
2369: WHEN no_data_found THEN

Line 2380: FROM hr_location_extra_info lei

2376: IF l_eit_count > 4 THEN
2377: BEGIN--Local8
2378: SELECT min(lei_information1)
2379: INTO l_min_year
2380: FROM hr_location_extra_info lei
2381: WHERE location_id = l_location_id
2382: AND information_type = 'EEO-1 Archive Information';
2383: END;--Local8
2384: BEGIN--Local9

Line 2387: FROM hr_location_extra_info lei

2383: END;--Local8
2384: BEGIN--Local9
2385: SELECT location_extra_info_id, object_version_number
2386: INTO l_location_extra_info_id,l_object_version_number
2387: FROM hr_location_extra_info lei
2388: WHERE lei_information1 = l_min_year
2389: AND information_type = 'EEO-1 Archive Information'
2390: AND location_id = l_location_id;
2391: END;--Local9

Line 2393: hr_location_extra_info_api.delete_location_extra_info

2389: AND information_type = 'EEO-1 Archive Information'
2390: AND location_id = l_location_id;
2391: END;--Local9
2392: BEGIN--Local10
2393: hr_location_extra_info_api.delete_location_extra_info
2394: (p_validate => false -- true
2395: ,p_location_extra_info_id => l_location_extra_info_id
2396: ,p_object_version_number => l_object_version_number
2397: );