DBA Data[Home] [Help]

APPS.ARH_ADDR_PKG dependencies on HZ_LOC_ASSIGNMENTS

Line 1989: hz_loc_assignments loc_assign

1985: into location_identifier
1986: from hz_cust_acct_sites acct_site,
1987: hz_party_sites party_site,
1988: hz_locations loc,
1989: hz_loc_assignments loc_assign
1990: where acct_site.party_site_id = party_site.party_site_id
1991: and loc.location_id = party_site.location_id
1992: and loc.location_id = loc_assign.location_id
1993: and nvl(acct_site.org_id,-99) = nvl(loc_assign.org_id, -99)