[Home] [Help]
386: WHERE (r.object_id = i_party_id
387: OR
388: r.object_id IN (SELECT DISTINCT ha.party_id
389: FROM hz_cust_accounts ha
390: ,hz_cust_acct_relate_all rel
391: ,hz_cust_accounts hz
392: WHERE ha.cust_account_id=rel.related_cust_account_id
393: AND rel.cust_account_id=hz.cust_account_id
394: AND rel.status='A'