DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 1701: FROM hz_cust_accounts cust_acct,

1697: FROM DUAL
1698: WHERE EXISTS
1699: (
1700: SELECT 'commitments_exist'
1701: FROM hz_cust_accounts cust_acct,
1702: so_agreements soa,
1703: hz_cust_acct_sites acct_site,
1704: ra_cust_trx_types inv_type,
1705: ra_cust_trx_types type,

Line 1728: hz_cust_accounts acc

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