1184: AND h.quote_status_id = sb.quote_status_id;
1185:
1186: CURSOR so_status_csr IS
1187: SELECT flow_status_code AS contract_status_code
1188: FROM oe_order_headers_all
1189: WHERE header_id = p_document_id;
1190:
1191: CURSOR bsa_status_csr IS
1192: SELECT flow_status_code AS contract_status_code
1508: WHERE quote_header_id = p_document_id;
1509:
1510: CURSOR so_org_csr IS
1511: SELECT org_id
1512: FROM oe_order_headers_all
1513: WHERE header_id = p_document_id;
1514:
1515: CURSOR bsa_org_csr IS
1516: SELECT org_id