APPS.AR_ARYVTSLD_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 46: HZ_CUST_ACCT_SITES ACCT_SITE,

42: LOC.POSTAL_CODE,
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