APPS.PER_ADD_BUS dependencies on PAY_US_ZIP_CODES

Line 2100: , pay_us_zip_codes z

2096: from
2097: pay_us_city_names a
2098: , pay_us_counties b
2099: , pay_us_states c
2100: , pay_us_zip_codes z
2101: where a.state_code = c.state_code
2102: and a.county_code = b.county_code
2103: and b.state_code = c.state_code
2104: and a.city_code=z.city_code

Line 3431: from pay_us_zip_codes zip,

3427: and cty.city_name = p_town_or_city;
3428: --
3429: cursor csr_valid_zip_code is
3430: select 1
3431: from pay_us_zip_codes zip,
3432: pay_us_city_names cty
3433: where zip.state_code = l_state_code
3434: and zip.county_code = l_county_code
3435: and cty.city_name = p_town_or_city

Line 3454: from pay_us_zip_codes zip,

3450: --
3451: --
3452: cursor csr_valid_zip_code_no_ncty is
3453: select 1
3454: from pay_us_zip_codes zip,
3455: pay_us_city_names cty
3456: where cty.city_name = p_town_or_city
3457: and cty.state_code = l_state_code
3458: and zip.state_code = cty.state_code

Line 3732: from pay_us_zip_codes zip,

3728: and cty.city_name = p_tax_city;
3729: --
3730: cursor csr_valid_zip_code is
3731: select 1
3732: from pay_us_zip_codes zip,
3733: pay_us_city_names cty
3734: where zip.state_code = l_state_code
3735: and zip.county_code = l_county_code
3736: and cty.city_name = p_tax_city

Line 3755: from pay_us_zip_codes zip,

3751: --
3752: --
3753: cursor csr_valid_zip_code_no_ncty is
3754: select 1
3755: from pay_us_zip_codes zip,
3756: pay_us_city_names cty
3757: where cty.city_name = p_tax_city
3758: and cty.state_code = l_state_code
3759: and zip.state_code = cty.state_code