APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_ACCOUNT_ROLES
Line 410: , hz_cust_account_roles r
406:
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