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
774: FROM PO_HEADERS_ALL
775: WHERE PO_HEADER_ID = cp_trx_id;
776:
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
774: FROM PO_HEADERS_ALL
775: WHERE PO_HEADER_ID = cp_trx_id;
776:
777: cursor c_fetch_sob_from_hrou(cp_org_id in number)
778: is