APPS.ARP_UTIL dependencies on HZ_PARTIES

Line 1527: hz_parties party

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
1530: c.account_number = p_value
1531: AND c.party_id = party.party_id;

Line 1543: hz_parties party

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
1546: and cp.site_use_id is null
1547: and party.party_name = p_value;