APPS.ASO_TAX_INT dependencies on HZ_PARTIES

Line 804: from hz_parties

800: where vat_tax_id = c_tax_id;
801:
802: cursor getpartyname (p_party_id number) is
803: select party_name
804: from hz_parties
805: where party_id = p_party_id;
806:
807: cursor c_global_attributes( p_inventory_item_id number, p_organization_id number) is
808: select global_attribute1, global_attribute2

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;