APPS.HZ_PARTY_V2PUB dependencies on HZ_RELATIONSHIPS

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

700:
701: CURSOR c_party_rels IS
702: SELECT r.party_id, r.object_id, o.party_name, r.subject_id, s.party_name,
703: rel.party_number, rel.party_name
704: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
705: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
706: AND r.party_id IS NOT NULL
707: AND r.subject_table_name = 'HZ_PARTIES'
708: AND r.object_table_name = 'HZ_PARTIES'

Line 9045: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

9041: ---(Party level relationship )
9042: CURSOR c_party_cust_acct_sites(p_party_id NUMBER) IS
9043: SELECT distinct ac.CUST_ACCT_SITE_ID
9044: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
9045: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
9046: WHERE rel.subject_id=p_party_id
9047: AND ar.ROLE_TYPE = 'CONTACT'
9048: AND rel.party_id=ar.party_id
9049: AND rel.subject_id=p.party_id

Line 9057: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

9053: ----(Site Level relationship)
9054: CURSOR c_site_cust_acct_sites(p_party_id NUMBER) IS
9055: SELECT distinct ac.CUST_ACCT_SITE_ID
9056: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
9057: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
9058: WHERE rel.subject_id=p_party_id
9059: AND ar.ROLE_TYPE = 'CONTACT'
9060: AND ar.party_id = rel.party_id
9061: AND p.party_id = rel.subject_id