DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 112: aso_quote_headers_all h

108: CURSOR quote_contract_csr(p_contract_id IN NUMBER, p_contract_type IN VARCHAR2) IS
109: SELECT
110: h.org_id
111: FROM
112: aso_quote_headers_all h
113: ,okc_template_usages t
114: WHERE h.quote_header_id = t.document_id
115: AND t.document_type = 'QUOTE'
116: AND t.document_type = p_contract_type

Line 123: aso_quote_headers_all h

119: CURSOR quote_security_csr(p_contract_id IN NUMBER) IS
120: SELECT
121: NULL
122: FROM
123: aso_quote_headers_all h
124: WHERE h.quote_header_id = p_contract_id
125: AND get_quote_access(
126: (SELECT s.resource_id
127: FROM jtf_rs_salesreps s