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_VETS_MAG_REPORT dependencies on PER_GEN_HIERARCHY_NODES

Line 176: from --per_gen_hierarchy_nodes pghn,

172: loc.postal_code zip_code,
173: hoi2.org_information2 naics,
174: hoi2.org_information4 duns,
175: hoi2.org_information3 ein
176: from --per_gen_hierarchy_nodes pghn,
177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,

Line 177: per_gen_hierarchy_nodes pgn,

173: hoi2.org_information2 naics,
174: hoi2.org_information4 duns,
175: hoi2.org_information3 ein
176: from --per_gen_hierarchy_nodes pghn,
177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,
181: hr_locations_all loc

Line 211: from per_gen_hierarchy_nodes pgn,

207: loc.postal_code zip_code,
208: upper(replace(replace(hoi2.org_information2,'-',''),',','')) naics, --bug 13905482
209: upper(replace(replace(hoi2.org_information4,'-',''),',','')) duns, --bug 13905482
210: upper(replace(replace(hoi2.org_information3,'-',''),',','')) ein --bug 13905482
211: from per_gen_hierarchy_nodes pgn,
212: hr_all_organization_units hou, -- vik
213: -- hr_organization_units hou, -- vik
214: hr_organization_information hoi1,
215: hr_organization_information hoi2,

Line 242: ,per_gen_hierarchy_nodes pgn

238: hr_organization_information hoi1
239: ,hr_locations_all cloc
240: ,hr_organization_units hou
241: ,hr_organization_information hoi2
242: ,per_gen_hierarchy_nodes pgn
243: where
244: hoi1.organization_id = pgn.entity_id
245: and hoi1.org_information_context = 'VETS_Spec'
246: and hoi1.organization_id = hou.organization_id

Line 1056: from per_gen_hierarchy_nodes pghn,

1052: upper(replace(replace(hlei2.lei_information6,'-',''),',','')) ein, --bug 13905482
1053: hlei2.lei_information10 hq,
1054: eloc.location_id,
1055: pghn.hierarchy_node_id
1056: from per_gen_hierarchy_nodes pghn,
1057: hr_location_extra_info hlei1,
1058: hr_location_extra_info hlei2,
1059: hr_locations_all eloc
1060: where pghn.hierarchy_version_id = p_hierarchy_version_id

Line 1132: from per_gen_hierarchy_nodes

1128: and ass.effective_start_date <= p_end_date
1129: and ass.effective_end_date >= p_start_date
1130: and to_char(ass.location_id) in
1131: (select entity_id
1132: from per_gen_hierarchy_nodes
1133: where hierarchy_version_id = p_hierarchy_version_id
1134: and (hierarchy_node_id = l_hierarchy_node_id
1135: or parent_hierarchy_node_id = l_hierarchy_node_id))
1136: group by hrl.lookup_code; */

Line 1227: from per_gen_hierarchy_nodes

1223: and p_end_date between ass.effective_start_date and ass.effective_end_date
1224: --
1225: and ass.location_id in
1226: (select entity_id
1227: from per_gen_hierarchy_nodes
1228: where hierarchy_version_id = p_hierarchy_version_id
1229: and (hierarchy_node_id = l_hierarchy_node_id
1230: or parent_hierarchy_node_id = l_hierarchy_node_id
1231: ))

Line 1299: from per_gen_hierarchy_nodes

1295: and job.job_information1 = hrl.lookup_code
1296: and hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1297: and to_char(ass.location_id) in
1298: (select entity_id
1299: from per_gen_hierarchy_nodes
1300: where hierarchy_version_id = p_hierarchy_version_id
1301: and (hierarchy_node_id = l_hierarchy_node_id
1302: or parent_hierarchy_node_id = l_hierarchy_node_id))
1303: group by hrl.lookup_code;

Line 1377: from per_gen_hierarchy_nodes

1373: AND hoi2.org_information_context = 'Reporting Categories'
1374: AND hoi1.organization_id = hoi2.organization_id)
1375: and ass.location_id in
1376: (select entity_id
1377: from per_gen_hierarchy_nodes
1378: where hierarchy_version_id = p_hierarchy_version_id
1379: and (hierarchy_node_id = l_hierarchy_node_id
1380: or parent_hierarchy_node_id = l_hierarchy_node_id
1381: ))

Line 1407: from per_gen_hierarchy_nodes

1403: between ppf.effective_start_date
1404: and ppf.effective_end_date
1405: and to_char(paf.location_id) in
1406: (select entity_id
1407: from per_gen_hierarchy_nodes
1408: where hierarchy_version_id = p_hierarchy_version_id
1409: and (hierarchy_node_id = l_hierarchy_node_id
1410: or parent_hierarchy_node_id = l_hierarchy_node_id));
1411: */

Line 1434: from per_gen_hierarchy_nodes

1430: and hoi2.organization_id = p_business_group_id
1431: --
1432: and ass.location_id in
1433: (select entity_id
1434: from per_gen_hierarchy_nodes
1435: where hierarchy_version_id = p_hierarchy_version_id
1436: and (hierarchy_node_id = l_hierarchy_node_id
1437: or parent_hierarchy_node_id = l_hierarchy_node_id
1438: ));

Line 1467: FROM per_gen_hierarchy_nodes

1463: )
1464: AND paf.business_group_id = p_business_group_id
1465: AND paf.location_id in --#10332486 Removed to_char
1466: (SELECT entity_id
1467: FROM per_gen_hierarchy_nodes
1468: WHERE hierarchy_version_id = p_hierarchy_version_id
1469: AND (hierarchy_node_id = l_hierarchy_node_id
1470: OR parent_hierarchy_node_id = l_hierarchy_node_id
1471: ))

Line 1510: FROM per_gen_hierarchy_nodes

1506: and paf2.effective_start_date
1507: <= p_end_date)
1508: AND paf.location_id in --#10332486 Removed to_char
1509: (SELECT entity_id
1510: FROM per_gen_hierarchy_nodes
1511: WHERE hierarchy_version_id = p_hierarchy_version_id
1512: AND (hierarchy_node_id = l_hierarchy_node_id
1513: OR parent_hierarchy_node_id = l_hierarchy_node_id
1514: ))

Line 1936: from per_gen_hierarchy_nodes

1932: l_string varchar2(2000);
1933: --
1934: cursor c2 is
1935: select count(*)
1936: from per_gen_hierarchy_nodes
1937: where node_type = 'EST'
1938: and hierarchy_version_id = p_hierarchy_version_id;
1939: --
1940: l_count number;