APPS.AR_CM_VAL_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 312: FROM hz_cust_acct_relate rcr

308: ot.status=decode(p_show_closed_invoices,'Y',ot.status,'OP') and
309: ot.terms_sequence_number = p_installment and
310: ot.customer_id IN (
311: SELECT rcr.related_cust_account_id
312: FROM hz_cust_acct_relate rcr
313: WHERE rcr.status='A' and
314: rcr.cust_account_id= p_cm_customer_id
315: and rcr.bill_to_flag = 'Y'
316: UNION