APPS.ASO_APR_WF_PVT dependencies on HZ_PARTIES

Line 4200: hz_parties hp

4196: c_quote_header_id NUMBER
4197: ) IS
4198: SELECT hp.party_name
4199: FROM aso_quote_headers_all qha,
4200: hz_parties hp
4201: WHERE qha.cust_party_id = hp.party_id
4202: AND qha.quote_header_id = c_quote_header_id;
4203:
4204: -- bug 3934660 (put outer join)

Line 4230: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4226: -- bug 3934660
4227:
4228: CURSOR get_party_type (c_approval_id NUMBER) IS
4229: SELECT P.PARTY_TYPE
4230: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4231: WHERE p.party_id = qh.party_id
4232: AND qh.quote_header_id = aoa.object_id
4233: AND aoa.object_approval_id = c_approval_id;
4234:

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'

Line 5035: hz_parties hp,

5031: c_quote_header_id NUMBER
5032: ) IS
5033: SELECT hca.cust_account_id, hp.party_type
5034: FROM aso_quote_headers_all qha,
5035: hz_parties hp,
5036: hz_cust_accounts hca
5037: WHERE qha.quote_header_id = c_quote_header_id
5038: AND nvl(qha.cust_account_id,0 ) = hca.cust_account_id (+)
5039: AND qha.cust_party_id = hp.party_id;