484: --
485: C_PARTY_CUST_TABLE CONSTANT VARCHAR2(32000) := '
486: ,hz_parties hzp
487: ,hz_party_sites hps
488: ,hz_cust_accounts hca
489: ,hz_cust_acct_sites_all hcas
490: ,hz_cust_site_uses_all hcsu
491: ';
492:
1537:
1538: SELECT hzp.party_name
1539: INTO p_third_party_name
1540: FROM hz_parties hzp
1541: ,hz_cust_accounts hca
1542: WHERE hzp.party_id = hca.party_id
1543: AND hca.cust_account_id = l_party_id;
1544:
1545: ELSIF l_party_type_code = 'S' THEN