1171: WHERE po_header_id = p_document_id;
1172:
1173: CURSOR neg_status_csr IS
1174: SELECT auction_status AS contract_status_code
1175: FROM pon_auction_headers_all
1176: WHERE auction_header_id = p_document_id;
1177:
1178: CURSOR quote_status_csr IS
1179: SELECT sb.status_code AS contract_status_code
1498: WHERE po_header_id = p_document_id;
1499:
1500: CURSOR neg_org_csr IS
1501: SELECT org_id
1502: FROM pon_auction_headers_all
1503: WHERE auction_header_id = p_document_id;
1504:
1505: CURSOR quote_org_csr IS
1506: SELECT org_id