[Home] [Help]
64: CURSOR po_contract_csr(p_contract_id IN NUMBER, p_contract_type IN VARCHAR2) IS
65: SELECT
66: h.org_id
67: FROM
68: po_headers_all h
69: ,okc_template_usages t
70: WHERE h.po_header_id = t.document_id
71: AND t.document_type IN ('PA_BLANKET','PA_CONTRACT','PO_STANDARD')
72: AND t.document_type = p_contract_type