763: where header_id = cp_trx_id;
764: --added by zhiwei.xin for OM end.
765:
766: --Added by Wenqiong for PO integration begin
767: CURSOR c_get_req_org_id(cp_trx_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE ) IS
768: SELECT org_id
769: FROM PO_REQUISITION_HEADERS_ALL
770: WHERE REQUISITION_HEADER_ID = cp_trx_id;
771:
765:
766: --Added by Wenqiong for PO integration begin
767: CURSOR c_get_req_org_id(cp_trx_id PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID%TYPE ) IS
768: SELECT org_id
769: FROM PO_REQUISITION_HEADERS_ALL
770: WHERE REQUISITION_HEADER_ID = cp_trx_id;
771:
772: CURSOR c_get_po_org_id(cp_trx_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE ) IS
773: SELECT org_id