187: SELECT preparer_id,
188: authorization_status
189: INTO l_preparer_id,
190: l_authorization_status
191: FROM po_requisition_headers
192: WHERE requisition_header_id = p_document_id;
193:
194: EXCEPTION
195: WHEN NO_DATA_FOUND THEN
1432: l_authorization_status,
1433: l_is_request_change_order,
1434: l_old_wf_item_type1,
1435: l_old_wf_item_key1
1436: FROM po_requisition_headers
1437: WHERE requisition_header_id = p_document_id;
1438:
1439: /**
1440: ** Bug 3912354: add code to include RCOs as possible candidates for