DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_PUB dependencies on AR_PAYING_RELATIONSHIPS_V

Line 12057: FROM ar_paying_relationships_v rel,

12053: AND r.status = 'A'
12054: AND r.bill_to_flag = 'Y'
12055: UNION
12056: SELECT rel.related_cust_account_id
12057: FROM ar_paying_relationships_v rel,
12058: hz_cust_accounts acc
12059: WHERE rel.party_id = acc.party_id
12060: AND acc.cust_account_id = l_rec_customer_id
12061: AND l_rec_date BETWEEN effective_start_date