APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_ACCOUNT_ROLES
Line 463: , hz_cust_account_roles r
459:
460: CURSOR contact_party_id_csr (p_contact_id in number) is
461: select p.party_id
462: from hz_parties p 463: , hz_cust_account_roles r 464: , hz_relationships rel
465: where r.cust_account_role_id = p_contact_id
466: and r.party_id = rel.party_id
467: and rel.subject_id = p.party_id