APPS.JA_JAINARE1_XMLP_PKG dependencies on HZ_PARTY_SITES

Line 80: HZ_PARTY_SITES HZPS,

76: SELECT
77: HZL.COUNTRY COUNTRY
78: FROM
79: HZ_LOCATIONS HZL,
80: HZ_PARTY_SITES HZPS,
81: HZ_CUST_ACCT_SITES_ALL HZCAS
82: WHERE HZL.LOCATION_ID = HZPS.LOCATION_ID
83: AND HZPS.PARTY_SITE_ID = HZCAS.PARTY_SITE_ID
84: AND HZCAS.CUST_ACCT_SITE_ID = P_ADDRESS_ID;