DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 1466: FROM hz_cust_accounts c,

1462: customer */
1463:
1464: SELECT c.cust_account_id
1465: INTO l_selected_id
1466: FROM hz_cust_accounts c,
1467: hz_customer_profiles cp,
1468: hz_parties party
1469: WHERE c.cust_account_id = cp.cust_account_id (+) and
1470: cp.site_use_id is null and

Line 1482: FROM hz_cust_accounts cust_acct,

1478: decode statement as everyone is now considered a
1479: customer */
1480: SELECT cust_acct.cust_account_id
1481: INTO l_selected_id
1482: FROM hz_cust_accounts cust_acct,
1483: hz_customer_profiles cp,
1484: hz_parties party
1485: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
1486: and cust_acct.party_id = party.party_id