DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 1611: FROM hz_cust_accounts cust_acct,

1607: FROM DUAL
1608: WHERE EXISTS
1609: (
1610: SELECT 'commitments_exist'
1611: FROM hz_cust_accounts cust_acct,
1612: so_agreements soa,
1613: hz_cust_acct_sites acct_site,
1614: ra_cust_trx_types inv_type,
1615: ra_cust_trx_types type,

Line 1638: hz_cust_accounts acc

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
1642: AND effective_end_date