APPS.ASO_SALES_CREDIT_PVT dependencies on HZ_PARTY_SITES

Line 446: FROM HZ_PARTY_SITES A, HZ_LOCATIONS B

442: WHERE Party_Id = l_party_id;
443:
444: CURSOR C_Get_Party_Site_Info (l_party_site NUMBER) IS
445: SELECT UPPER(B.city) City, UPPER(B.county) County, UPPER(B.state)State, UPPER(B.province) Province, B.postal_code, B.country
446: FROM HZ_PARTY_SITES A, HZ_LOCATIONS B
447: WHERE A.Location_Id = B.Location_Id
448: AND A.party_site_id = l_party_site;
449:
450: CURSOR C_Get_Cust_Cont_Info (l_party_id NUMBER) IS