DBA Data[Home] [Help]

APPS.HR_US_PYZIPCHK dependencies on PAY_US_ZIP_CODES

Line 34: pay_us_zip_codes pc

30:
31: select count(*)
32: from pay_us_counties co,
33: pay_ca_cities_v ct,
34: pay_us_zip_codes pc
35: where co.state_code = '70'
36: and co.county_code = ct.province_code
37: and co.county_code = pc.county_code
38: and pc.state_code = '70'

Line 121: pay_us_zip_codes pc

117:
118: select count(*)
119: from pay_us_counties co,
120: pay_ca_cities_v ct,
121: pay_us_zip_codes pc
122: where co.state_code = '70'
123: and co.county_code = ct.province_code
124: and co.county_code = pc.county_code
125: and pc.state_code = '70'