APPS.ASO_APR_WF_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 2244: FROM aso_quote_headers_all

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

Line 2251: FROM aso_quote_headers_all

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

Line 4221: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

4217: CURSOR get_object_details (
4218: c_approval_id NUMBER
4219: ) IS
4220: SELECT quote_header_id, quote_name, quote_number, quote_expiration_date
4221: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
4222: WHERE qha.quote_header_id = aoa.object_id
4223: AND aoa.object_approval_id = c_approval_id;
4224:
4225: CURSOR get_customer_name (

Line 4229: FROM aso_quote_headers_all qha,

4225: CURSOR get_customer_name (
4226: c_quote_header_id NUMBER
4227: ) IS
4228: SELECT hp.party_name
4229: FROM aso_quote_headers_all qha,
4230: hz_parties hp
4231: WHERE qha.cust_party_id = hp.party_id
4232: AND qha.quote_header_id = c_quote_header_id;
4233:

Line 4240: aso_quote_headers_all qha

4236: c_quote_header_id NUMBER
4237: ) IS
4238: SELECT hca.account_number
4239: FROM hz_cust_accounts hca,
4240: aso_quote_headers_all qha
4241: WHERE qha.cust_account_id = hca.cust_account_id(+)
4242: AND qha.quote_header_id = c_quote_header_id;
4243:
4244: CURSOR get_opportunity_name (

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

4256: -- bug 3934660
4257:
4258: CURSOR get_party_type (c_approval_id NUMBER) IS
4259: SELECT P.PARTY_TYPE
4260: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4261: WHERE p.party_id = qh.party_id
4262: AND qh.quote_header_id = aoa.object_id
4263: AND aoa.object_approval_id = c_approval_id;
4264:

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'

Line 5054: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5050: CURSOR get_object_details (
5051: c_approval_id NUMBER
5052: ) IS
5053: SELECT quote_header_id, quote_number,qha.org_id
5054: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5055: WHERE qha.quote_header_id = aoa.object_id
5056: AND aoa.object_approval_id = c_approval_id;
5057:
5058: -- bug 3934660 replace qha.party_id with cust_party_id

Line 5064: FROM aso_quote_headers_all qha,

5060: CURSOR get_quote_details (
5061: c_quote_header_id NUMBER
5062: ) IS
5063: SELECT hca.cust_account_id, hp.party_type
5064: FROM aso_quote_headers_all qha,
5065: hz_parties hp,
5066: hz_cust_accounts hca
5067: WHERE qha.quote_header_id = c_quote_header_id
5068: AND nvl(qha.cust_account_id,0 ) = hca.cust_account_id (+)

Line 5456: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5452: CURSOR OBJECT (
5453: c_approval_id NUMBER
5454: ) IS
5455: SELECT quote_name, quote_number,org_id,quote_header_id
5456: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5457: WHERE qha.quote_header_id = aoa.object_id
5458: AND aoa.object_approval_id = c_approval_id;
5459:
5460: BEGIN