APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_LOCATIONS

Line 2316: hz_locations loc

2312: SELECT loc.location_id
2313: INTO l_location_id
2314: FROM hz_cust_acct_sites acct_site,
2315: hz_party_sites party_site,
2316: hz_locations loc
2317: WHERE acct_site.party_site_id = party_site.party_site_id
2318: AND loc.location_id = party_site.location_id
2319: AND acct_site.cust_acct_site_id = p_cust_acct_site_id ;
2320:

Line 3192: from hz_locations

3188:
3189: IF p_location_id IS NOT NULL THEN
3190: select object_version_number
3191: into l_version_num
3192: from hz_locations
3193: where location_id = p_location_id;
3194: END IF;
3195:
3196: IF p_cust_account_id IS NOT NULL THEN

Line 3230: hz_locations loc

3226: INTO l_location_id
3227: FROM hz_cust_site_uses site_uses,
3228: hz_cust_acct_sites acct_site,
3229: hz_party_sites party_site,
3230: hz_locations loc
3231: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
3232: AND acct_site.party_site_id = party_site.party_site_id
3233: AND loc.location_id = party_site.location_id
3234: AND site_uses.site_use_code = p_site_usage_code

Line 3836: hz_locations loc

3832: INTO x_site_use_id
3833: FROM hz_cust_acct_sites acct_site,
3834: hz_cust_site_uses site_uses,
3835: hz_party_sites party_site,
3836: hz_locations loc
3837: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
3838: AND acct_site.party_site_id = party_site.party_site_id
3839: AND loc.location_id = party_site.location_id
3840: AND site_uses.site_use_code = p_site_usage