APPS.ASO_TAX_INT dependencies on HZ_PARTY_SITES

Line 740: hz_party_sites party_site_ship,

736: s_ship.tax_rounding_rule
737: FROM
738: hz_cust_site_uses_all s_ship ,
739: hz_cust_acct_sites acct_site_ship,
740: hz_party_sites party_site_ship,
741: hz_locations loc_ship,
742: hz_loc_assignments loc_assign_ship,
743: hz_cust_accounts cust_acct
744: WHERE s_ship.site_use_id = l_site_use_id

Line 761: from hz_party_sites sps,

757: --End of comments Yogeshwar (MOAC)
758: --Need ORG striped synonym for HZ_LOC_ASSIGNMENTS
759: cursor getpartyinfo is
760: select sl.postal_code, sla.loc_id, sl.location_id
761: from hz_party_sites sps,
762: hz_locations sl,
763: hz_loc_assignments sla
764: where sps.party_site_id = l_party_site_id
765: and SPS.location_id = SL.location_id

Line 2293: FROM hz_party_sites

2289: AND ORG_ID= l_qte_line_rec.organization_id;
2290:
2291: Cursor c_shiplocation(l_party_site_id NUMBER) is
2292: select LOCATION_ID
2293: FROM hz_party_sites
2294: WHERE party_site_id=l_party_site_id;
2295:
2296: Cursor c_tax is
2297: select TAX_EXEMPT_FLAG,TAX_EXEMPT_NUMBER,TAX_EXEMPT_REASON_CODE