DBA Data[Home] [Help]

APPS.PA_LOCATION_UTILS dependencies on PER_ADDRESSES

Line 291: FROM per_addresses l,

287: INTO x_country_code,
288: x_country_name,
289: x_city,
290: x_region
291: FROM per_addresses l,
292: fnd_territories_vl t
293: WHERE t.territory_code = l.country
294: AND l.primary_flag = 'Y'
295: AND p_assign_date between l.DATE_FROM and nvl(l.DATE_TO, p_assign_date)