DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_PAYING_RELATIONSHIPS_V

Line 1637: FROM ar_paying_relationships_v rel,

1633: select to_number(p_bill_to_customer_id)
1634: from dual
1635: UNION
1636: SELECT acc.cust_account_id
1637: FROM ar_paying_relationships_v rel,
1638: hz_cust_accounts acc
1639: WHERE rel.party_id = acc.party_id
1640: AND rel.related_cust_account_id = p_bill_to_customer_id
1641: AND l_trx_date BETWEEN effective_start_date