APPS.HR_US_PYZIPCHK dependencies on PAY_CA_CITIES_V

Line 33: pay_ca_cities_v ct,

29: /* rmonge bug 4000003 */
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

Line 48: , pay_ca_cities_v ct

44:
45: /* Commenting out this script as it has some performance problems.
46: select count(*)
47: from pay_ca_provinces_v pr
48: , pay_ca_cities_v ct
49: , pay_ca_postal_codes_v pc
50: where pr.province_code = ct.province_code
51: and pr.province_code = pc.province_code
52: and ct.city_code = pc.city_code

Line 120: pay_ca_cities_v ct,

116: /* rmonge 4000003 */
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

Line 135: , pay_ca_cities_v ct

131: --
132: /*
133: select count(*)
134: from pay_ca_provinces_v pr
135: , pay_ca_cities_v ct
136: , pay_ca_postal_codes_v pc
137: where pr.province_code = ct.province_code
138: and pr.province_code = pc.province_code
139: and ct.city_code = pc.city_code