DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 110: aso_quote_headers_all h

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

Line 121: aso_quote_headers_all h

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