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_SINGLE_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 134: ,hr_locations_all eloc

130: from
131: hr_location_extra_info hlei1
132: ,hr_location_extra_info hlei2
133: ,per_gen_hierarchy_nodes pghn
134: ,hr_locations_all eloc
135: where
136: pghn.parent_hierarchy_node_id = l_parent_node_id
137: and pghn.node_type = 'EST'
138: and eloc.location_id = pghn.entity_id

Line 182: l_parent_city hr_locations_all.town_or_city%type;

178: l_reporting_name hr_organization_information.org_information1%type;
179: l_company_number hr_organization_information.org_information2%type;
180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;

Line 183: l_parent_county hr_locations_all.region_1%type;

179: l_company_number hr_organization_information.org_information2%type;
180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;

Line 184: l_parent_state hr_locations_all.region_2%type;

180: l_type_of_rep_org hr_organization_information.org_information3%type;
181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;

Line 185: l_parent_zip hr_locations_all.postal_code%type;

181: l_parent_address clob;
182: l_parent_city hr_locations_all.town_or_city%type;
183: l_parent_county hr_locations_all.region_1%type;
184: l_parent_state hr_locations_all.region_2%type;
185: l_parent_zip hr_locations_all.postal_code%type;
186: l_contact_name hr_organization_information.org_information17%type;
187: l_contact_telnum hr_organization_information.org_information18%type;
188: l_contact_email hr_organization_information.org_information20%type;
189: l_contact_telnum_and_email hr_organization_information.org_information20%type;

Line 206: l_est_city hr_locations_all.town_or_city%type;

202: l_est_naics varchar2(20);
203: l_est_gre varchar2(20);
204: l_headquarters varchar2(20);
205: l_est_address clob;
206: l_est_city hr_locations_all.town_or_city%type;
207: l_est_county hr_locations_all.town_or_city%type;
208: l_est_state hr_locations_all.region_2%type;
209: l_est_zip hr_locations_all.postal_code%type;
210:

Line 207: l_est_county hr_locations_all.town_or_city%type;

203: l_est_gre varchar2(20);
204: l_headquarters varchar2(20);
205: l_est_address clob;
206: l_est_city hr_locations_all.town_or_city%type;
207: l_est_county hr_locations_all.town_or_city%type;
208: l_est_state hr_locations_all.region_2%type;
209: l_est_zip hr_locations_all.postal_code%type;
210:
211: l_50_emps number;

Line 208: l_est_state hr_locations_all.region_2%type;

204: l_headquarters varchar2(20);
205: l_est_address clob;
206: l_est_city hr_locations_all.town_or_city%type;
207: l_est_county hr_locations_all.town_or_city%type;
208: l_est_state hr_locations_all.region_2%type;
209: l_est_zip hr_locations_all.postal_code%type;
210:
211: l_50_emps number;
212:

Line 209: l_est_zip hr_locations_all.postal_code%type;

205: l_est_address clob;
206: l_est_city hr_locations_all.town_or_city%type;
207: l_est_county hr_locations_all.town_or_city%type;
208: l_est_state hr_locations_all.region_2%type;
209: l_est_zip hr_locations_all.postal_code%type;
210:
211: l_50_emps number;
212:
213: CS_NO_DIS_VETS number:=0;