APPS.ASO_APR_WF_PVT dependencies on HZ_RELATIONSHIPS

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

4237: CURSOR get_contact_name (
4238: c_approval_id NUMBER
4239: ) IS
4240: SELECT party_name
4241: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4242: WHERE p.party_id = r.object_id
4243: AND r.party_id = qh.party_id
4244: AND r.subject_id = qh.cust_party_id
4245: AND r.object_type = 'PERSON'