APPS.ASO_APR_WF_PVT dependencies on HZ_RELATIONSHIPS

Line 4271: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4267: CURSOR get_contact_name (
4268: c_approval_id NUMBER
4269: ) IS
4270: SELECT party_name
4271: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4272: WHERE p.party_id = r.object_id
4273: AND r.party_id = qh.party_id
4274: AND r.subject_id = qh.cust_party_id
4275: AND r.object_type = 'PERSON'