APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_MODIFIED_GEOCODES

Line 84: INSERT INTO pay_us_modified_geocodes

80: 'P',
81: l_mode,
82: 'US');
83:
84: INSERT INTO pay_us_modified_geocodes
85: (city_name,
86: state_code,
87: county_code,
88: new_city_code,

Line 115: FROM pay_us_modified_geocodes pumg

111: AND pugu.process_type = pps.process_type
112: AND pugu.process_mode = pps.phase
113: AND NOT EXISTS
114: (SELECT NULL
115: FROM pay_us_modified_geocodes pumg
116: WHERE pumg.city_name = substr(pugu.description,3)
117: AND pumg.state_code = substr(pugu.old_juri_code,1,2)
118: AND pumg.county_code = substr(pugu.old_juri_code,4,3)
119: AND pumg.new_city_code = substr(pugu.new_juri_code,8,4)