DBA Data[Home] [Help]

APPS.ONT_ICP_GET_USER_DETAILS dependencies on HZ_CUST_ACCOUNTS

Line 30: FROM hz_parties h,hz_cust_accounts c

26:
27: CURSOR c_customer(in_party_id IN VARCHAR2) IS
28: SELECT cust_account_id,
29: party_name
30: FROM hz_parties h,hz_cust_accounts c
31: WHERE c.party_id = h.party_id
32: AND h.party_id = ( SELECT object_id
33: FROM hz_relationships r
34: WHERE r.party_id = in_party_id