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 193: from hr_locations_all hr ;

189: hr.region_1,
190: hr.region_2,
191: hr.town_or_city,
192: hr.postal_code
193: from hr_locations_all hr ;
194:
195: type hrlocrow is record
196: (
197: location_id hr_locations_all.location_id%TYPE,

Line 197: location_id hr_locations_all.location_id%TYPE,

193: from hr_locations_all hr ;
194:
195: type hrlocrow is record
196: (
197: location_id hr_locations_all.location_id%TYPE,
198: region_1 hr_locations_all.region_1%TYPE,
199: region_2 hr_locations_all.region_2%TYPE,
200: town_or_city hr_locations_all.town_or_city%TYPE,
201: postal_code hr_locations_all.postal_code%TYPE

Line 198: region_1 hr_locations_all.region_1%TYPE,

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

Line 199: region_2 hr_locations_all.region_2%TYPE,

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

Line 200: town_or_city hr_locations_all.town_or_city%TYPE,

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

Line 201: postal_code hr_locations_all.postal_code%TYPE

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