865: --
866: C_PARTY_CUST_TABLE CONSTANT VARCHAR2(32000) := '
867: ,hz_parties hzp
868: ,hz_party_sites hps
869: ,hz_cust_accounts hca
870: ,hz_cust_acct_sites_all hcas
871: ,hz_cust_site_uses_all hcsu
872: ';
873:
2010:
2011: SELECT hzp.party_name
2012: INTO p_third_party_name
2013: FROM hz_parties hzp
2014: ,hz_cust_accounts hca
2015: WHERE hzp.party_id = hca.party_id
2016: AND hca.cust_account_id = l_party_id;
2017:
2018: ELSIF l_party_type_code = 'S' THEN