APPS.HZ_PARTY_V2PUB dependencies on HZ_RELATIONSHIPS

Line 697: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel

693:
694: CURSOR c_party_rels IS
695: SELECT r.party_id, r.object_id, o.party_name, r.subject_id, s.party_name,
696: rel.party_number, rel.party_name
697: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
698: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
699: AND r.party_id IS NOT NULL
700: AND r.subject_table_name = 'HZ_PARTIES'
701: AND r.object_table_name = 'HZ_PARTIES'

Line 8933: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

8929: ---(Party level relationship )
8930: CURSOR c_party_cust_acct_sites(p_party_id NUMBER) IS
8931: SELECT distinct ac.CUST_ACCT_SITE_ID
8932: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
8933: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
8934: WHERE rel.subject_id=p_party_id
8935: AND ar.ROLE_TYPE = 'CONTACT'
8936: AND rel.party_id=ar.party_id
8937: AND rel.subject_id=p.party_id

Line 8945: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

8941: ----(Site Level relationship)
8942: CURSOR c_site_cust_acct_sites(p_party_id NUMBER) IS
8943: SELECT distinct ac.CUST_ACCT_SITE_ID
8944: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
8945: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
8946: WHERE rel.subject_id=p_party_id
8947: AND ar.ROLE_TYPE = 'CONTACT'
8948: AND ar.party_id = rel.party_id
8949: AND p.party_id = rel.subject_id