APPS.ONT_ICP_GET_USER_DETAILS dependencies on HZ_RELATIONSHIPS

Line 33: FROM hz_relationships r

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
35: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
36: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
37: AND r.DIRECTIONAL_FLAG = 'F'

Line 45: FROM hz_relationships r

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
47: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
48: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
49: AND r.DIRECTIONAL_FLAG = 'F' );