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_US_VETS_100A_CONS_PKG dependencies on HR_LOCATIONS_ALL

Line 84: ,hr_locations_all cloc

80: ,hoi2.org_information20 contact_email
81: ,substr(hoi2.org_information18,1,20) || ' ' ||hoi2.org_information20 contact_telnum_and_email
82: from
83: hr_organization_information hoi1
84: ,hr_locations_all cloc
85: ,hr_organization_units hou
86: ,hr_organization_information hoi2
87: where
88: hoi1.organization_id = l_parent_org_id

Line 115: ,hr_locations_all eloc

111: from
112: hr_location_extra_info hlei1
113: ,hr_location_extra_info hlei2
114: ,per_gen_hierarchy_nodes pghn
115: ,hr_locations_all eloc
116: where
117: pghn.parent_hierarchy_node_id = l_parent_node_id
118: and pghn.node_type = 'EST'
119: and eloc.location_id = pghn.entity_id

Line 150: ,hr_locations_all eloc

146: from
147: per_gen_hierarchy_nodes pghn1
148: ,hr_location_extra_info hlei1
149: ,hr_location_extra_info hlei2
150: ,hr_locations_all eloc
151: where
152: pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
153: and pghn1.node_type = 'EST'
154: and eloc.location_id = pghn1.entity_id

Line 219: l_parent_city hr_locations_all.town_or_city%type;

215: l_reporting_name hr_organization_information.org_information1%type;
216: l_company_number hr_organization_information.org_information2%type;
217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;

Line 220: l_parent_county hr_locations_all.region_1%type;

216: l_company_number hr_organization_information.org_information2%type;
217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;

Line 221: l_parent_state hr_locations_all.region_2%type;

217: l_type_of_rep_org hr_organization_information.org_information3%type;
218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;

Line 222: l_parent_zip hr_locations_all.postal_code%type;

218: l_parent_address clob;
219: l_parent_city hr_locations_all.town_or_city%type;
220: l_parent_county hr_locations_all.region_1%type;
221: l_parent_state hr_locations_all.region_2%type;
222: l_parent_zip hr_locations_all.postal_code%type;
223: l_contact_name hr_organization_information.org_information17%type;
224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;

Line 228: l_state hr_locations_all.region_2%type;

224: l_contact_telnum hr_organization_information.org_information18%type;
225: l_contact_email hr_organization_information.org_information20%type;
226: l_contact_telnum_and_email hr_organization_information.org_information20%type;
227:
228: l_state hr_locations_all.region_2%type;
229: l_state_meaning varchar2(20);
230:
231: l_def_sic varchar2(20);
232: l_def_naics varchar2(20);

Line 292: ,hr_locations_all eloc

288: from
289: hr_location_extra_info hlei1
290: ,hr_location_extra_info hlei2
291: ,per_gen_hierarchy_nodes pghn
292: ,hr_locations_all eloc
293: where
294: pghn.hierarchy_version_id = p_hierarchy_version_id
295: and pghn.parent_hierarchy_node_id = p_parent_node_id
296: and eloc.location_id = pghn.entity_id