APPS.ARI_UTILITIES dependencies on HZ_RELATIONSHIPS

Line 817: from hz_relationships hr,

813: INTO user_access
814: FROM dual
815: WHERE p_customer_id IN (
816: select hca.cust_account_id
817: from hz_relationships hr,
818: hz_parties hp1,
819: hz_parties hp2,
820: hz_cust_accounts hca
821: where hr.subject_id = hp1.party_id

Line 969: HZ_RELATIONSHIPS REL

965: substrb(PARTY.PERSON_LAST_NAME,1,50)
966: INTO l_contact_name
967: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
968: HZ_PARTIES PARTY,
969: HZ_RELATIONSHIPS REL
970: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
971: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
972: AND REL.SUBJECT_ID = PARTY.PARTY_ID
973: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1021: HZ_RELATIONSHIPS REL

1017: substrb(PARTY.PERSON_LAST_NAME,1,50)
1018: INTO l_contact_name
1019: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
1020: HZ_PARTIES PARTY,
1021: HZ_RELATIONSHIPS REL
1022: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1023: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
1024: AND REL.SUBJECT_ID = PARTY.PARTY_ID
1025: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,

2247: CURSOR contact_cur(p_customer_id IN NUMBER ,
2248: p_customer_acct_site_id IN NUMBER ) IS
2249: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
2250: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
2252: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
2253: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
2254: and hrr.cust_account_role_id = hcar.cust_account_role_id
2255: and hcar.CUST_ACCOUNT_ID = p_customer_id