DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 388: ,hz_cust_acct_relate_all rel

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