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 PER_GEN_HIERARCHY_NODES

Line 268: FROM per_gen_hierarchy_nodes pgn,

264: SUBSTR(hoi2.org_information10,1,20) tel_num_24,
265: SUBSTR(hoi2.org_information14,1,10) fax_num_25,
266: SUBSTR(hoi2.org_information15,1,40) email_26,
267: hoi1.organization_id par_ent_org_id
268: FROM per_gen_hierarchy_nodes pgn,
269: hr_all_organization_units hou,
270: hr_organization_information hoi1,
271: hr_organization_information hoi2,
272: hr_organization_information hoi3

Line 296: FROM per_gen_hierarchy_nodes

292: AND p_start_date > paf.effective_start_date
293: AND p_end_date < paf.effective_end_date
294: AND paf.location_id IN
295: (SELECT entity_id
296: FROM per_gen_hierarchy_nodes
297: WHERE hierarchy_version_id = p_hierarchy_version_id
298: );
299:
300: l_max NUMBER;

Line 1909: FROM per_gen_hierarchy_nodes pghn,

1905: hlei2.lei_information3 sic_20,
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

Line 1938: FROM per_gen_hierarchy_nodes pgn

1934: AND p_start_date >= paf.effective_start_date
1935: AND p_end_date <= paf.effective_end_date
1936: AND TO_CHAR(paf.location_id) IN
1937: (SELECT entity_id
1938: FROM per_gen_hierarchy_nodes pgn
1939: WHERE
1940: pgn.hierarchy_version_id = p_hierarchy_version_id
1941: AND (
1942: pgn.hierarchy_node_id = l_hierarchy_node_id

Line 2011: FROM per_gen_hierarchy_nodes pgn

2007: AND p_start_date <= ass.effective_end_date
2008: AND p_end_date >= ass.effective_start_date
2009: AND TO_CHAR(ass.location_id) IN
2010: (SELECT entity_id
2011: FROM per_gen_hierarchy_nodes pgn
2012: WHERE
2013: pgn.hierarchy_version_id = p_hierarchy_version_id
2014: AND (
2015: pgn.hierarchy_node_id = l_hierarchy_node_id

Line 2049: per_gen_hierarchy_nodes pgn_est

2045: FROM per_all_people_f peo,
2046: per_all_assignments_f ass,
2047: per_jobs_vl job,
2048: hr_lookups hrl,
2049: per_gen_hierarchy_nodes pgn_est
2050: WHERE peo.person_id = ass.person_id
2051: --AND peo.per_information1 is not NULL commented for fix for #12616269
2052: -- Added for fix for #12616269
2053: AND EXISTS (SELECT 'X'

Line 2119: FROM per_gen_hierarchy_nodes pgn_loc

2115: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2116: AND pgn_est.business_group_id = p_business_group_id
2117: AND peo.sex = 'F'
2118: AND 1 > (SELECT count(*)
2119: FROM per_gen_hierarchy_nodes pgn_loc
2120: WHERE pgn_est.entity_id = pgn_loc.entity_id
2121: AND pgn_loc.node_type = 'LOC'
2122: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2123: AND pgn_loc.business_group_id = p_business_group_id)

Line 2153: per_gen_hierarchy_nodes pgn_est

2149: FROM per_all_people_f peo,
2150: per_all_assignments_f ass,
2151: per_jobs_vl job,
2152: hr_lookups hrl,
2153: per_gen_hierarchy_nodes pgn_est
2154: WHERE peo.person_id = ass.person_id
2155: --AND peo.per_information1 is not NULL commented for fix for #12616269
2156: -- Added for fix for #12616269
2157: AND EXISTS (SELECT 'X'

Line 2223: FROM per_gen_hierarchy_nodes pgn_loc

2219: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2220: AND pgn_est.business_group_id = p_business_group_id
2221: AND peo.sex = 'M'
2222: AND 1 > (SELECT count(*)
2223: FROM per_gen_hierarchy_nodes pgn_loc
2224: WHERE pgn_est.entity_id = pgn_loc.entity_id
2225: AND pgn_loc.node_type = 'LOC'
2226: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2227: AND pgn_loc.business_group_id = p_business_group_id)

Line 2241: per_gen_hierarchy_nodes pgn_est

2237: FROM per_all_people_f peo,
2238: per_all_assignments_f ass,
2239: per_jobs_vl job,
2240: hr_lookups hrl,
2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')

Line 2296: FROM per_gen_hierarchy_nodes pgn_loc

2292: AND pgn_est.node_type IN ('EST','LOC')
2293: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2294: AND pgn_est.business_group_id = p_business_group_id
2295: AND 1 > (SELECT count(*)
2296: FROM per_gen_hierarchy_nodes pgn_loc
2297: WHERE pgn_est.entity_id = pgn_loc.entity_id
2298: AND pgn_loc.node_type = 'LOC'
2299: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2300: AND pgn_loc.business_group_id = p_business_group_id)

Line 2340: ,per_gen_hierarchy_nodes pgn

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
2344: AND lei.location_id = pgn.entity_id

Line 2373: FROM per_gen_hierarchy_nodes pgn,

2369: SELECT eloc.location_id,
2370: eloc.location_code
2371: INTO l_location_id,
2372: l_location_code
2373: FROM per_gen_hierarchy_nodes pgn,
2374: hr_locations_all eloc
2375: WHERE (hierarchy_node_id = p_hierarchy_node_id
2376: or parent_hierarchy_node_id = p_hierarchy_node_id)
2377: AND hierarchy_version_id = p_hierarchy_version_id

Line 4555: FROM per_gen_hierarchy_nodes

4551: l_string VARCHAR2(5000); --1074
4552:
4553: CURSOR c_nodes(p_hierarchy_version_id NUMBER) IS
4554: SELECT count('establishments')
4555: FROM per_gen_hierarchy_nodes
4556: WHERE node_type = 'EST'
4557: AND hierarchy_version_id = p_hierarchy_version_id;
4558:
4559: l_count NUMBER;