APPS.ZX_TCM_GET_DEF_EXEMPTION dependencies on HZ_PARTY_SITES

Line 117: zx_party_tax_profile ptp_party_site, hz_party_sites ps

113: Ex.TAX_JURISDICTION_ID,
114: Ex.PARTY_TAX_PROFILE_ID
115: FROM
116: zx_exemptions ex, fnd_lookups lkp,
117: zx_party_tax_profile ptp_party_site, hz_party_sites ps
118: WHERE
119: Ex.exempt_reason_code = lkp.lookup_code and
120: Lkp.lookup_type = 'ZX_EXEMPTION_REASON_CODE' and
121: ex.exemption_status_code in ( 'PRIMARY', 'MANUAL', 'UNAPPROVED' ) and

Line 199: hz_party_sites hzp

195:
196: SELECT hzl.COUNTRY
197: INTO l_country_code
198: FROM hz_locations hzl,
199: hz_party_sites hzp
200: WHERE hzl.location_id = hzp.location_id
201: AND hzp.PARTY_SITE_ID = p_ship_to_party_site_id;
202:
203: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller