DBA Data[Home] [Help]

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