APPS.ASO_APR_WF_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 2243: FROM aso_quote_headers_all

2239: CURSOR check_contract_enabled (
2240: c_quote_header_id NUMBER
2241: ) IS
2242: SELECT contract_approval_level
2243: FROM aso_quote_headers_all
2244: WHERE quote_header_id = c_quote_header_id;
2245:
2246: CURSOR get_latest_date (
2247: c_quote_header_id NUMBER

Line 2250: FROM aso_quote_headers_all

2246: CURSOR get_latest_date (
2247: c_quote_header_id NUMBER
2248: ) IS
2249: SELECT last_update_date,org_id
2250: FROM aso_quote_headers_all
2251: WHERE quote_header_id = c_quote_header_id;
2252:
2253: CURSOR get_quote_status_id (
2254: v_status VARCHAR2

Line 4191: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

4187: CURSOR get_object_details (
4188: c_approval_id NUMBER
4189: ) IS
4190: SELECT quote_header_id, quote_name, quote_number, quote_expiration_date
4191: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
4192: WHERE qha.quote_header_id = aoa.object_id
4193: AND aoa.object_approval_id = c_approval_id;
4194:
4195: CURSOR get_customer_name (

Line 4199: FROM aso_quote_headers_all qha,

4195: CURSOR get_customer_name (
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:

Line 4210: aso_quote_headers_all qha

4206: c_quote_header_id NUMBER
4207: ) IS
4208: SELECT hca.account_number
4209: FROM hz_cust_accounts hca,
4210: aso_quote_headers_all qha
4211: WHERE qha.cust_account_id = hca.cust_account_id(+)
4212: AND qha.quote_header_id = c_quote_header_id;
4213:
4214: CURSOR get_opportunity_name (

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 5024: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5020: CURSOR get_object_details (
5021: c_approval_id NUMBER
5022: ) IS
5023: SELECT quote_header_id, quote_number,qha.org_id
5024: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5025: WHERE qha.quote_header_id = aoa.object_id
5026: AND aoa.object_approval_id = c_approval_id;
5027:
5028: -- bug 3934660 replace qha.party_id with cust_party_id

Line 5034: FROM aso_quote_headers_all qha,

5030: CURSOR get_quote_details (
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 (+)

Line 5423: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5419: CURSOR OBJECT (
5420: c_approval_id NUMBER
5421: ) IS
5422: SELECT quote_name, quote_number,org_id,quote_header_id
5423: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5424: WHERE qha.quote_header_id = aoa.object_id
5425: AND aoa.object_approval_id = c_approval_id;
5426:
5427: BEGIN