DBA Data[Home] [Help]

APPS.HZ_GEO_GET_PUB dependencies on HZ_GNR_UTIL_PKG

Line 299: l_postal_code := HZ_GNR_UTIL_PKG.postal_code_to_validate(l_country_code,l_postal_code);

295:
296: END IF;
297: --Bug13427431
298: --Getting postal_code based on profile value for 'HZ_VAL_FIRST_5_DIGIT_US_ZIP'
299: l_postal_code := HZ_GNR_UTIL_PKG.postal_code_to_validate(l_country_code,l_postal_code);
300:
301: -- Bug 6842648 Perf fix to query
302: -- Bug 7837051 Commented Master_ref_geography_id Join
303: SELECT count(1)