APPS.ARP_UTIL dependencies on HZ_PARTIES

Line 1468: hz_parties party

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
1472: AND c.party_id = party.party_id;

Line 1484: hz_parties party

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
1488: and party.party_name = p_value;