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 2294: FROM hz_party_sites

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

Line 2350: HZ_PARTIES a, HZ_PARTY_SITES b

2346:
2347: CURSOR C_SHIP(p_party_site_id NUMBER) IS
2348: SELECT a.party_id
2349: from
2350: HZ_PARTIES a, HZ_PARTY_SITES b
2351: WHERE a.status = 'A'
2352: and b.status = 'A'
2353: and b.party_site_id = p_party_site_id
2354: and b.party_id = a.party_id;