DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on PO_HEADERS_ALL

Line 1170: FROM po_headers_all

1166: WHERE contract_id = p_document_id;
1167:
1168: CURSOR po_status_csr IS
1169: SELECT NVL(authorization_status, 'INCOMPLETE') AS contract_status_code
1170: FROM po_headers_all
1171: WHERE po_header_id = p_document_id;
1172:
1173: CURSOR neg_status_csr IS
1174: SELECT auction_status AS contract_status_code

Line 1497: FROM po_headers_all

1493: WHERE contract_id = p_document_id;
1494:
1495: CURSOR po_org_csr IS
1496: SELECT org_id
1497: FROM po_headers_all
1498: WHERE po_header_id = p_document_id;
1499:
1500: CURSOR neg_org_csr IS
1501: SELECT org_id