APPS.HZ_CUSTOMER_INT dependencies on HZ_PARTY_SITES

Line 1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799

1978:
1979:
1980: CURSOR c IS -- Check if the party_site_number already exists
1981: SELECT decode(cust_site.orig_system_reference,p_orig_system_address_ref,'','Y6,')
1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799
1983: WHERE site.party_site_number = p_party_site_number
1984: AND cust_site.org_id = p_org_id -- bug 4454799
1985: AND site.party_site_id = cust_site.party_site_id;
1986:

Line 2087: hz_party_sites ps,

2083: CURSOR C1 IS
2084: SELECT loc.location_id,loc.country,loc.city, loc.state,
2085: loc.county, loc.province, loc.postal_code
2086: FROM hz_cust_acct_sites_all cs, -- bug 4454799
2087: hz_party_sites ps,
2088: hz_locations loc
2089: WHERE cs.orig_system_reference = p_orig_system_address_ref
2090: AND cs.org_id = p_org_id -- bug 4454799
2091: AND ps.party_site_id = cs.party_site_id

Line 2116: FROM hz_party_sites ps

2112: SELECT 'Y'
2113: INTO l_is_remit_to_location
2114: FROM DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM hz_party_sites ps
2117: WHERE ps.location_id = l_location_id
2118: AND ps.party_id = -1
2119: );
2120: EXCEPTION

Line 3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131

3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref
3320: AND loc.location_id = ps.location_id --4742586
3321: AND ps.request_id = p_request_id