APPS.ASO_PA_APR_WF_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 463: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

459: CURSOR OBJECT (
460: c_approval_id NUMBER
461: ) IS
462: SELECT quote_name, quote_number,org_id,quote_header_id
463: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
464: WHERE qha.quote_header_id = aoa.object_id
465: AND aoa.object_approval_id = c_approval_id;
466:
467: BEGIN

Line 2368: FROM aso_quote_headers_all

2364: CURSOR check_contract_enabled (
2365: c_quote_header_id NUMBER
2366: ) IS
2367: SELECT contract_approval_level
2368: FROM aso_quote_headers_all
2369: WHERE quote_header_id = c_quote_header_id;
2370:
2371: CURSOR get_latest_date (
2372: c_quote_header_id NUMBER

Line 2375: FROM aso_quote_headers_all

2371: CURSOR get_latest_date (
2372: c_quote_header_id NUMBER
2373: ) IS
2374: SELECT last_update_date,org_id
2375: FROM aso_quote_headers_all
2376: WHERE quote_header_id = c_quote_header_id;
2377:
2378: CURSOR get_quote_status_id (
2379: v_status VARCHAR2

Line 3646: from aso_quote_headers_all

3642: from aso_apr_obj_approvals
3643: where object_approval_id=l_approval_id;
3644:
3645: select quote_name,quote_number into l_quote_name,l_qte_number
3646: from aso_quote_headers_all
3647: where quote_header_id=l_qte_header_id;
3648:
3649: --pp_debug('quote number'||l_qte_number);
3650: --pp_debug('l_quote_name'||l_quote_name);