DBA Data[Home] [Help]

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