APPS.ONT_ICP_GET_USER_DETAILS dependencies on HZ_CUST_ACCOUNT_ROLES

Line 42: FROM hz_parties h,hz_cust_account_roles c

38: );
39:
40: CURSOR c_user(in_party_id IN VARCHAR2) IS
41: SELECT cust_account_role_id,party_name
42: FROM hz_parties h,hz_cust_account_roles c
43: WHERE c.party_id = h.party_id
44: AND h.party_id = ( SELECT subject_id
45: FROM hz_relationships r
46: WHERE r.party_id = in_party_id