DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 322: hz_cust_accounts acc

318: FROM dual
319: UNION
320: SELECT rel.related_cust_account_id
321: FROM ar_paying_relationships_v rel,
322: hz_cust_accounts acc
323: WHERE rel.party_id = acc.party_id
324: AND acc.cust_account_id = p_cm_customer_id
325: AND p_cm_trx_date BETWEEN effective_start_date
326: AND effective_end_date