APPS.PER_ADD_BUS dependencies on PAY_US_ZIP_CODES

Line 2068: select /*+index(Z PAY_US_ZIP_CODES_N1)

2064: ,p_town_or_city in per_addresses.town_or_city%TYPE)
2065: is
2066: -- Cursor Defination added for bug 5367066
2067: cursor get_city_address is
2068: select /*+index(Z PAY_US_ZIP_CODES_N1)
2069: index(Z PAY_US_ZIP_CODES_N2) */ c.state_abbrev
2070: , c.state_code
2071: ,a.city_name
2072: , a.city_code

Line 2069: index(Z PAY_US_ZIP_CODES_N2) */ c.state_abbrev

2065: is
2066: -- Cursor Defination added for bug 5367066
2067: cursor get_city_address is
2068: select /*+index(Z PAY_US_ZIP_CODES_N1)
2069: index(Z PAY_US_ZIP_CODES_N2) */ c.state_abbrev
2070: , c.state_code
2071: ,a.city_name
2072: , a.city_code
2073: , z.zip_start

Line 2081: , pay_us_zip_codes z

2077: from
2078: pay_us_city_names a
2079: , pay_us_counties b
2080: , pay_us_states c
2081: , pay_us_zip_codes z
2082: where a.state_code = c.state_code
2083: and a.county_code = b.county_code
2084: and b.state_code = c.state_code
2085: and a.city_code=z.city_code

Line 3412: from pay_us_zip_codes zip,

3408: and cty.city_name = p_town_or_city;
3409: --
3410: cursor csr_valid_zip_code is
3411: select 1
3412: from pay_us_zip_codes zip,
3413: pay_us_city_names cty
3414: where zip.state_code = l_state_code
3415: and zip.county_code = l_county_code
3416: and cty.city_name = p_town_or_city

Line 3435: from pay_us_zip_codes zip,

3431: --
3432: --
3433: cursor csr_valid_zip_code_no_ncty is
3434: select 1
3435: from pay_us_zip_codes zip,
3436: pay_us_city_names cty
3437: where cty.city_name = p_town_or_city
3438: and cty.state_code = l_state_code
3439: and zip.state_code = cty.state_code

Line 3713: from pay_us_zip_codes zip,

3709: and cty.city_name = p_tax_city;
3710: --
3711: cursor csr_valid_zip_code is
3712: select 1
3713: from pay_us_zip_codes zip,
3714: pay_us_city_names cty
3715: where zip.state_code = l_state_code
3716: and zip.county_code = l_county_code
3717: and cty.city_name = p_tax_city

Line 3736: from pay_us_zip_codes zip,

3732: --
3733: --
3734: cursor csr_valid_zip_code_no_ncty is
3735: select 1
3736: from pay_us_zip_codes zip,
3737: pay_us_city_names cty
3738: where cty.city_name = p_tax_city
3739: and cty.state_code = l_state_code
3740: and zip.state_code = cty.state_code