APPS.AR_ARYVTSLD_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 47: HZ_PARTY_SITES PARTY_SITE,

43: LOC.COUNTRY
44: INTO C_BRANCH,C_STREET,C_CITY,C_POSTAL_CODE,C_COUNTRY
45: FROM
46: HZ_CUST_ACCT_SITES ACCT_SITE,
47: HZ_PARTY_SITES PARTY_SITE,
48: HZ_LOCATIONS LOC
49: WHERE ACCT_SITE.CUST_ACCOUNT_ID = - 1
50: AND ACCT_SITE.CUST_ACCT_SITE_ID = P_REMIT_TO_ADDRESS
51: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID