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.XLE_UTILITIES_GRP dependencies on HR_LOCATIONS_ALL

Line 95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

91: LEGALAUTH_ADDRESS VARCHAR2(1000),
92: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
93: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
94: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

92: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
93: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
94: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

93: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
94: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

94: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

95: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

96: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
104: );

Line 101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

97: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
104: );
105:

Line 102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

98: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
104: );
105:
106: TYPE Registration_Tbl_Type IS TABLE OF Registration_Rec INDEX BY BINARY_INTEGER;

Line 103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

99: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
100: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
101: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
102: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
103: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
104: );
105:
106: TYPE Registration_Tbl_Type IS TABLE OF Registration_Rec INDEX BY BINARY_INTEGER;
107:

Line 126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

122: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
123: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
124: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
125: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

123: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
124: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
125: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

124: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
125: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

125: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

126: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

127: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
135: );

Line 132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

128: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
135: );
136:

Line 133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

129: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
135: );
136:
137: TYPE Establishment_Tbl_Type IS TABLE OF Establishment_Rec INDEX BY BINARY_INTEGER;

Line 134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

130: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
131: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
132: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
133: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
134: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
135: );
136:
137: TYPE Establishment_Tbl_Type IS TABLE OF Establishment_Rec INDEX BY BINARY_INTEGER;
138:

Line 156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,

152: LEGISLATIVE_CATEGORY XLE_JURISDICTIONS_VL.legislative_cat_code%TYPE,
153: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
154: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
155: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

Line 157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,

153: EFFECTIVE_FROM XLE_REGISTRATIONS.EFFECTIVE_FROM%TYPE,
154: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
155: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

Line 158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,

154: EFFECTIVE_TO XLE_REGISTRATIONS.EFFECTIVE_TO%TYPE,
155: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

Line 159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,

155: LOCATION_ID XLE_REGISTRATIONS.location_id%TYPE,
156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

Line 160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,

156: ADDRESS_LINE_1 HR_LOCATIONS_ALL.ADDRESS_LINE_1%TYPE,
157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

Line 161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,

157: ADDRESS_LINE_2 HR_LOCATIONS_ALL.ADDRESS_LINE_2%TYPE,
158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
165: );

Line 162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,

158: ADDRESS_LINE_3 HR_LOCATIONS_ALL.ADDRESS_LINE_3%TYPE,
159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
165: );
166:

Line 163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,

159: TOWN_OR_CITY HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE,
160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
165: );
166:
167: TYPE Legal_Entity_Tbl_Type IS TABLE OF LegalEntity_Rec INDEX BY BINARY_INTEGER;

Line 164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE

160: REGION_1 HR_LOCATIONS_ALL.REGION_1%TYPE,
161: REGION_2 HR_LOCATIONS_ALL.REGION_2%TYPE,
162: REGION_3 HR_LOCATIONS_ALL.REGION_3%TYPE,
163: POSTAL_CODE HR_LOCATIONS_ALL.POSTAL_CODE%TYPE,
164: COUNTRY HR_LOCATIONS_ALL.COUNTRY%TYPE
165: );
166:
167: TYPE Legal_Entity_Tbl_Type IS TABLE OF LegalEntity_Rec INDEX BY BINARY_INTEGER;
168: