DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on HZ_RELATIONSHIPS

Line 382: FROM hz_relationships r -- Bug 4654753

378: -- default contact id based on cust_acct_id and pseudo contact_id
379: CURSOR contact_id_csr(p_cust_account_id in number,
380: p_party_relationship_id in number) is
381: SELECT p.party_id -- ,p.party_name
382: FROM hz_relationships r -- Bug 4654753
383: , hz_parties p
384: , hz_cust_accounts c
385: WHERE r.subject_id = p.party_id
386: AND r.relationship_id = p_party_relationship_id -- Bug 4654753

Line 411: , hz_relationships rel

407: CURSOR contact_party_id_csr (p_contact_id in number) is
408: select p.party_id
409: from hz_parties p
410: , hz_cust_account_roles r
411: , hz_relationships rel
412: where r.cust_account_role_id = p_contact_id
413: and r.party_id = rel.party_id
414: and rel.subject_id = p.party_id
415: and SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6732: hz_relationships r,

6728: p_relation_type in varchar2,
6729: p_party_id in number) IS
6730: SELECT count(p.party_id)
6731: FROM hz_parties p,
6732: hz_relationships r,
6733: hz_cust_accounts c
6734: WHERE p.party_id = r.subject_id
6735: AND r.relationship_code = p_relation_type
6736: AND r.object_id = c.party_id