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

Line 7: -- HR_LOCATIONS_ALL and PER_ADDRESSES tables.

3: --
4: --
5: -- This procedure is used to flag out and shows the details
6: -- of the addresses which have invalid zip codes in both
7: -- HR_LOCATIONS_ALL and PER_ADDRESSES tables.
8: -- This script holds procedures and functions that are
9: -- used to display all the invalid existing addresses in the hr_location_all
10: -- and per_addresses. It produces a report of all the addresses which
11: -- contain invlid zip code. This is done by calling the inval_addr

Line 194: from hr_locations_all hr

190: hr.region_1,
191: hr.region_2,
192: hr.town_or_city,
193: hr.postal_code
194: from hr_locations_all hr
195: where hr.style in ('US','CA') or hr.country in ('US','CA') ;--Added for Bug#8982883
196:
197: type hrlocrow is record
198: (

Line 199: location_id hr_locations_all.location_id%TYPE,

195: where hr.style in ('US','CA') or hr.country in ('US','CA') ;--Added for Bug#8982883
196:
197: type hrlocrow is record
198: (
199: location_id hr_locations_all.location_id%TYPE,
200: region_1 hr_locations_all.region_1%TYPE,
201: region_2 hr_locations_all.region_2%TYPE,
202: town_or_city hr_locations_all.town_or_city%TYPE,
203: postal_code hr_locations_all.postal_code%TYPE

Line 200: region_1 hr_locations_all.region_1%TYPE,

196:
197: type hrlocrow is record
198: (
199: location_id hr_locations_all.location_id%TYPE,
200: region_1 hr_locations_all.region_1%TYPE,
201: region_2 hr_locations_all.region_2%TYPE,
202: town_or_city hr_locations_all.town_or_city%TYPE,
203: postal_code hr_locations_all.postal_code%TYPE
204:

Line 201: region_2 hr_locations_all.region_2%TYPE,

197: type hrlocrow is record
198: (
199: location_id hr_locations_all.location_id%TYPE,
200: region_1 hr_locations_all.region_1%TYPE,
201: region_2 hr_locations_all.region_2%TYPE,
202: town_or_city hr_locations_all.town_or_city%TYPE,
203: postal_code hr_locations_all.postal_code%TYPE
204:
205: /* commented to change the type

Line 202: town_or_city hr_locations_all.town_or_city%TYPE,

198: (
199: location_id hr_locations_all.location_id%TYPE,
200: region_1 hr_locations_all.region_1%TYPE,
201: region_2 hr_locations_all.region_2%TYPE,
202: town_or_city hr_locations_all.town_or_city%TYPE,
203: postal_code hr_locations_all.postal_code%TYPE
204:
205: /* commented to change the type
206: location_id number(15),

Line 203: postal_code hr_locations_all.postal_code%TYPE

199: location_id hr_locations_all.location_id%TYPE,
200: region_1 hr_locations_all.region_1%TYPE,
201: region_2 hr_locations_all.region_2%TYPE,
202: town_or_city hr_locations_all.town_or_city%TYPE,
203: postal_code hr_locations_all.postal_code%TYPE
204:
205: /* commented to change the type
206: location_id number(15),
207: region_1 varchar2(70),