APPS.ARI_UTILITIES dependencies on HZ_RELATIONSHIPS

Line 775: from hz_relationships hr,

771: INTO user_access
772: FROM dual
773: WHERE p_customer_id IN (
774: select hca.cust_account_id
775: from hz_relationships hr,
776: hz_parties hp1,
777: hz_parties hp2,
778: hz_cust_accounts hca
779: where hr.subject_id = hp1.party_id

Line 927: HZ_RELATIONSHIPS REL

923: substrb(PARTY.PERSON_LAST_NAME,1,50)
924: INTO l_contact_name
925: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
926: HZ_PARTIES PARTY,
927: HZ_RELATIONSHIPS REL
928: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = l_contact_id
929: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
930: AND REL.SUBJECT_ID = PARTY.PARTY_ID
931: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 979: HZ_RELATIONSHIPS REL

975: substrb(PARTY.PERSON_LAST_NAME,1,50)
976: INTO l_contact_name
977: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
978: HZ_PARTIES PARTY,
979: HZ_RELATIONSHIPS REL
980: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
981: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
982: AND REL.SUBJECT_ID = PARTY.PARTY_ID
983: AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

1810: CURSOR contact_cur(p_customer_id IN NUMBER DEFAULT NULL,
1811: p_customer_acct_site_id IN NUMBER DEFAULT NULL ) IS
1812: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
1813: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
1814: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
1815: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
1816: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
1817: and hrr.cust_account_role_id = hcar.cust_account_role_id
1818: and hcar.CUST_ACCOUNT_ID = p_customer_id