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 1876: FROM per_gen_hierarchy_nodes pghn,

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

Line 1905: FROM per_gen_hierarchy_nodes pgn

1901: AND p_start_date >= paf.effective_start_date
1902: AND p_end_date <= paf.effective_end_date
1903: AND TO_CHAR(paf.location_id) IN
1904: (SELECT entity_id
1905: FROM per_gen_hierarchy_nodes pgn
1906: WHERE
1907: pgn.hierarchy_version_id = p_hierarchy_version_id
1908: AND (
1909: pgn.hierarchy_node_id = l_hierarchy_node_id

Line 1959: FROM per_gen_hierarchy_nodes pgn

1955: AND p_start_date <= ass.effective_end_date
1956: AND p_end_date >= ass.effective_start_date
1957: AND TO_CHAR(ass.location_id) IN
1958: (SELECT entity_id
1959: FROM per_gen_hierarchy_nodes pgn
1960: WHERE
1961: pgn.hierarchy_version_id = p_hierarchy_version_id
1962: AND (
1963: pgn.hierarchy_node_id = l_hierarchy_node_id

Line 1986: per_gen_hierarchy_nodes pgn_est

1982: FROM per_all_people_f peo,
1983: per_all_assignments_f ass,
1984: per_jobs_vl job,
1985: hr_lookups hrl,
1986: per_gen_hierarchy_nodes pgn_est
1987: WHERE peo.person_id = ass.person_id
1988: AND peo.per_information1 IS not NULL
1989: AND peo.per_information_category = 'US'
1990: AND job.job_information_category = 'US'

Line 2037: FROM per_gen_hierarchy_nodes pgn_loc

2033: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2034: AND pgn_est.business_group_id = p_business_group_id
2035: AND peo.sex = 'F'
2036: AND 1 > (SELECT count(*)
2037: FROM per_gen_hierarchy_nodes pgn_loc
2038: WHERE pgn_est.entity_id = pgn_loc.entity_id
2039: AND pgn_loc.node_type = 'LOC'
2040: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2041: AND pgn_loc.business_group_id = p_business_group_id)

Line 2060: per_gen_hierarchy_nodes pgn_est

2056: FROM per_all_people_f peo,
2057: per_all_assignments_f ass,
2058: per_jobs_vl job,
2059: hr_lookups hrl,
2060: per_gen_hierarchy_nodes pgn_est
2061: WHERE peo.person_id = ass.person_id
2062: AND peo.per_information1 IS NOT NULL
2063: AND peo.per_information_category = 'US'
2064: AND job.job_information_category = 'US'

Line 2111: FROM per_gen_hierarchy_nodes pgn_loc

2107: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2108: AND pgn_est.business_group_id = p_business_group_id
2109: AND peo.sex = 'M'
2110: AND 1 > (SELECT count(*)
2111: FROM per_gen_hierarchy_nodes pgn_loc
2112: WHERE pgn_est.entity_id = pgn_loc.entity_id
2113: AND pgn_loc.node_type = 'LOC'
2114: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2115: AND pgn_loc.business_group_id = p_business_group_id)

Line 2129: per_gen_hierarchy_nodes pgn_est

2125: FROM per_all_people_f peo,
2126: per_all_assignments_f ass,
2127: per_jobs_vl job,
2128: hr_lookups hrl,
2129: per_gen_hierarchy_nodes pgn_est
2130: WHERE peo.person_id = ass.person_id
2131: AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2132: AND peo.per_information_category = 'US'
2133: AND job.job_information_category = 'US'

Line 2178: FROM per_gen_hierarchy_nodes pgn_loc

2174: AND pgn_est.node_type IN ('EST','LOC')
2175: AND pgn_est.hierarchy_version_id = p_hierarchy_version_id
2176: AND pgn_est.business_group_id = p_business_group_id
2177: AND 1 > (SELECT count(*)
2178: FROM per_gen_hierarchy_nodes pgn_loc
2179: WHERE pgn_est.entity_id = pgn_loc.entity_id
2180: AND pgn_loc.node_type = 'LOC'
2181: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2182: AND pgn_loc.business_group_id = p_business_group_id)

Line 2207: ,per_gen_hierarchy_nodes pgn

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

Line 2240: FROM per_gen_hierarchy_nodes pgn,

2236: SELECT eloc.location_id,
2237: eloc.location_code
2238: INTO l_location_id,
2239: l_location_code
2240: FROM per_gen_hierarchy_nodes pgn,
2241: hr_locations_all eloc
2242: WHERE (hierarchy_node_id = p_hierarchy_node_id
2243: or parent_hierarchy_node_id = p_hierarchy_node_id)
2244: AND hierarchy_version_id = p_hierarchy_version_id

Line 4316: FROM per_gen_hierarchy_nodes

4312: l_string VARCHAR2(5000); --1074
4313:
4314: CURSOR c_nodes(p_hierarchy_version_id NUMBER) IS
4315: SELECT count('establishments')
4316: FROM per_gen_hierarchy_nodes
4317: WHERE node_type = 'EST'
4318: AND hierarchy_version_id = p_hierarchy_version_id;
4319:
4320: l_count NUMBER;