DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_PAYING_RELATIONSHIPS_V

Line 1727: FROM ar_paying_relationships_v rel,

1723: select to_number(p_bill_to_customer_id)
1724: from dual
1725: UNION
1726: SELECT acc.cust_account_id
1727: FROM ar_paying_relationships_v rel,
1728: hz_cust_accounts acc
1729: WHERE rel.party_id = acc.party_id
1730: AND rel.related_cust_account_id = p_bill_to_customer_id
1731: AND l_trx_date BETWEEN effective_start_date