DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 1525: FROM hz_cust_accounts c,

1521: customer */
1522:
1523: SELECT c.cust_account_id
1524: INTO l_selected_id
1525: FROM hz_cust_accounts c,
1526: hz_customer_profiles cp,
1527: hz_parties party
1528: WHERE c.cust_account_id = cp.cust_account_id (+) and
1529: cp.site_use_id is null and

Line 1541: FROM hz_cust_accounts cust_acct,

1537: decode statement as everyone is now considered a
1538: customer */
1539: SELECT cust_acct.cust_account_id
1540: INTO l_selected_id
1541: FROM hz_cust_accounts cust_acct,
1542: hz_customer_profiles cp,
1543: hz_parties party
1544: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
1545: and cust_acct.party_id = party.party_id