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 161: from --per_gen_hierarchy_nodes pghn,

157: loc.postal_code zip_code,
158: hoi2.org_information2 naics,
159: hoi2.org_information4 duns,
160: hoi2.org_information3 ein
161: from --per_gen_hierarchy_nodes pghn,
162: per_gen_hierarchy_nodes pgn,
163: hr_organization_units hou,
164: hr_organization_information hoi1,
165: hr_organization_information hoi2,

Line 162: per_gen_hierarchy_nodes pgn,

158: hoi2.org_information2 naics,
159: hoi2.org_information4 duns,
160: hoi2.org_information3 ein
161: from --per_gen_hierarchy_nodes pghn,
162: per_gen_hierarchy_nodes pgn,
163: hr_organization_units hou,
164: hr_organization_information hoi1,
165: hr_organization_information hoi2,
166: hr_locations_all loc

Line 197: from per_gen_hierarchy_nodes pgn,

193: loc.postal_code zip_code,
194: hoi2.org_information2 naics,
195: hoi2.org_information4 duns,
196: hoi2.org_information3 ein
197: from per_gen_hierarchy_nodes pgn,
198: hr_all_organization_units hou, -- vik
199: -- hr_organization_units hou, -- vik
200: hr_organization_information hoi1,
201: hr_organization_information hoi2,

Line 947: from per_gen_hierarchy_nodes pghn,

943: hlei2.lei_information6 ein,
944: hlei2.lei_information10 hq,
945: eloc.location_id,
946: pghn.hierarchy_node_id
947: from per_gen_hierarchy_nodes pghn,
948: hr_location_extra_info hlei1,
949: hr_location_extra_info hlei2,
950: hr_locations_all eloc
951: where pghn.hierarchy_version_id = p_hierarchy_version_id

Line 1023: from per_gen_hierarchy_nodes

1019: and ass.effective_start_date <= p_end_date
1020: and ass.effective_end_date >= p_start_date
1021: and to_char(ass.location_id) in
1022: (select entity_id
1023: from per_gen_hierarchy_nodes
1024: where hierarchy_version_id = p_hierarchy_version_id
1025: and (hierarchy_node_id = l_hierarchy_node_id
1026: or parent_hierarchy_node_id = l_hierarchy_node_id))
1027: group by hrl.lookup_code; */

Line 1113: from per_gen_hierarchy_nodes

1109: and p_end_date between ass.effective_start_date and ass.effective_end_date
1110: --
1111: and ass.location_id in
1112: (select entity_id
1113: from per_gen_hierarchy_nodes
1114: where hierarchy_version_id = p_hierarchy_version_id
1115: and (hierarchy_node_id = l_hierarchy_node_id
1116: or parent_hierarchy_node_id = l_hierarchy_node_id
1117: ))

Line 1185: from per_gen_hierarchy_nodes

1181: and job.job_information1 = hrl.lookup_code
1182: and hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1183: and to_char(ass.location_id) in
1184: (select entity_id
1185: from per_gen_hierarchy_nodes
1186: where hierarchy_version_id = p_hierarchy_version_id
1187: and (hierarchy_node_id = l_hierarchy_node_id
1188: or parent_hierarchy_node_id = l_hierarchy_node_id))
1189: group by hrl.lookup_code;

Line 1261: from per_gen_hierarchy_nodes

1257: AND hoi2.org_information_context = 'Reporting Categories'
1258: AND hoi1.organization_id = hoi2.organization_id)
1259: and ass.location_id in
1260: (select entity_id
1261: from per_gen_hierarchy_nodes
1262: where hierarchy_version_id = p_hierarchy_version_id
1263: and (hierarchy_node_id = l_hierarchy_node_id
1264: or parent_hierarchy_node_id = l_hierarchy_node_id
1265: ))

Line 1291: from per_gen_hierarchy_nodes

1287: between ppf.effective_start_date
1288: and ppf.effective_end_date
1289: and to_char(paf.location_id) in
1290: (select entity_id
1291: from per_gen_hierarchy_nodes
1292: where hierarchy_version_id = p_hierarchy_version_id
1293: and (hierarchy_node_id = l_hierarchy_node_id
1294: or parent_hierarchy_node_id = l_hierarchy_node_id));
1295: */

Line 1318: from per_gen_hierarchy_nodes

1314: and hoi2.organization_id = p_business_group_id
1315: --
1316: and ass.location_id in
1317: (select entity_id
1318: from per_gen_hierarchy_nodes
1319: where hierarchy_version_id = p_hierarchy_version_id
1320: and (hierarchy_node_id = l_hierarchy_node_id
1321: or parent_hierarchy_node_id = l_hierarchy_node_id
1322: ));

Line 1349: FROM per_gen_hierarchy_nodes

1345: )
1346: AND paf.business_group_id = p_business_group_id
1347: AND to_char(paf.location_id) in
1348: (SELECT entity_id
1349: FROM per_gen_hierarchy_nodes
1350: WHERE hierarchy_version_id = p_hierarchy_version_id
1351: AND (hierarchy_node_id = l_hierarchy_node_id
1352: OR parent_hierarchy_node_id = l_hierarchy_node_id
1353: ))

Line 1389: FROM per_gen_hierarchy_nodes

1385: and paf2.effective_start_date
1386: <= p_end_date)
1387: AND to_char(paf.location_id) in
1388: (SELECT entity_id
1389: FROM per_gen_hierarchy_nodes
1390: WHERE hierarchy_version_id = p_hierarchy_version_id
1391: AND (hierarchy_node_id = l_hierarchy_node_id
1392: OR parent_hierarchy_node_id = l_hierarchy_node_id
1393: ))

Line 1790: from per_gen_hierarchy_nodes

1786: l_string varchar2(2000);
1787: --
1788: cursor c2 is
1789: select count(*)
1790: from per_gen_hierarchy_nodes
1791: where node_type = 'EST'
1792: and hierarchy_version_id = p_hierarchy_version_id;
1793: --
1794: l_count number;