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 1910: hr_location_extra_info hlei1,

1906: hlei2.lei_information4 naics_21,
1907: pghn.hierarchy_node_id,
1908: hlei2.lei_information10 hq
1909: FROM per_gen_hierarchy_nodes pghn,
1910: hr_location_extra_info hlei1,
1911: hr_location_extra_info hlei2,
1912: hr_locations_all eloc
1913: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1914: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus

Line 1911: hr_location_extra_info hlei2,

1907: pghn.hierarchy_node_id,
1908: hlei2.lei_information10 hq
1909: FROM per_gen_hierarchy_nodes pghn,
1910: hr_location_extra_info hlei1,
1911: hr_location_extra_info hlei2,
1912: hr_locations_all eloc
1913: WHERE -- pghn.hierarchy_version_id = 2683 -- sd1
1914: pghn.hierarchy_version_id = p_hierarchy_version_id -- 2803 sd10plus
1915: -- pghn.hierarchy_version_id = 2823 -- Vik SD Albuquereque

Line 2339: FROM hr_location_extra_info lei

2335: ,lei_information13 p_ifemale
2336: ,lei_information17 p_tmracesfemale
2337: ,lei_information3 p_total
2338:
2339: FROM hr_location_extra_info lei
2340: ,per_gen_hierarchy_nodes pgn
2341: WHERE lei.lei_information1 = l_prev_year_filed
2342: AND lei.information_type = 'EEO-1 Archive Information'
2343: -- BUG3646445

Line 2390: FROM hr_location_extra_info

2386: SELECT 'U',
2387: location_extra_info_id
2388: INTO p_update,
2389: l_location_extra_info_id
2390: FROM hr_location_extra_info
2391: WHERE lei_information1 = p_report_year
2392: AND lei_information_category = 'EEO-1 Archive Information'
2393: AND location_id = l_location_id;
2394: EXCEPTION

Line 2421: FROM hr_location_extra_info

2417:
2418: BEGIN--Local3
2419: SELECT object_version_number
2420: INTO l_object_version_number
2421: FROM hr_location_extra_info
2422: WHERE location_extra_info_id = l_location_extra_info_id;
2423: END;--Local3
2424:
2425: BEGIN --Local4

Line 2426: hr_location_extra_info_api.delete_location_extra_info

2422: WHERE location_extra_info_id = l_location_extra_info_id;
2423: END;--Local3
2424:
2425: BEGIN --Local4
2426: hr_location_extra_info_api.delete_location_extra_info
2427: (p_validate => false -- true
2428: ,p_location_extra_info_id => l_location_extra_info_id
2429: ,p_object_version_number => l_object_version_number
2430: );

Line 2449: hr_location_extra_info_api.create_location_extra_info

2445:
2446: BEGIN--Local5
2447: -- Bug 7447266
2448: /*
2449: hr_location_extra_info_api.create_location_extra_info
2450: (p_validate => false -- true
2451: ,p_location_id => l_location_id
2452: ,p_information_type => 'EEO-1 Archive Information'
2453: ,p_lei_information_category => 'EEO-1 Archive Information'

Line 2477: hr_location_extra_info_api.create_location_extra_info

2473: ,p_object_version_number => l_object_version_number
2474: );
2475: */
2476:
2477: hr_location_extra_info_api.create_location_extra_info
2478: (p_validate => false -- true
2479: ,p_location_id => l_location_id
2480: ,p_information_type => 'EEO-1 Archive Information'
2481: ,p_lei_information_category => 'EEO-1 Archive Information'

Line 2529: FROM hr_location_extra_info lei

2525: BEGIN--Local7
2526:
2527: SELECT count(*)
2528: INTO l_eit_count
2529: FROM hr_location_extra_info lei
2530: WHERE location_id = l_location_id
2531: AND information_type = 'EEO-1 Archive Information';
2532: EXCEPTION
2533: WHEN no_data_found THEN

Line 2544: FROM hr_location_extra_info lei

2540: IF l_eit_count > 4 THEN
2541: BEGIN--Local8
2542: SELECT min(lei_information1)
2543: INTO l_min_year
2544: FROM hr_location_extra_info lei
2545: WHERE location_id = l_location_id
2546: AND information_type = 'EEO-1 Archive Information';
2547: END;--Local8
2548: BEGIN--Local9

Line 2551: FROM hr_location_extra_info lei

2547: END;--Local8
2548: BEGIN--Local9
2549: SELECT location_extra_info_id, object_version_number
2550: INTO l_location_extra_info_id,l_object_version_number
2551: FROM hr_location_extra_info lei
2552: WHERE lei_information1 = l_min_year
2553: AND information_type = 'EEO-1 Archive Information'
2554: AND location_id = l_location_id;
2555: END;--Local9

Line 2557: hr_location_extra_info_api.delete_location_extra_info

2553: AND information_type = 'EEO-1 Archive Information'
2554: AND location_id = l_location_id;
2555: END;--Local9
2556: BEGIN--Local10
2557: hr_location_extra_info_api.delete_location_extra_info
2558: (p_validate => false -- true
2559: ,p_location_extra_info_id => l_location_extra_info_id
2560: ,p_object_version_number => l_object_version_number
2561: );