DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on HZ_CUSTOMER_PROFILES

Line 1467: hz_customer_profiles cp,

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
1471: c.account_number = p_value

Line 1483: hz_customer_profiles cp,

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
1487: and cp.site_use_id is null