DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on OKC_K_HEADERS_V

Line 1413: ,OKC_K_HEADERS_V okh

1409: FUNCTION get_case_contracts(p_case_number in varchar2) RETURN VARCHAR2 AS
1410: CURSOR l_contract_csr(cp_case_number in varchar2) IS SELECT okh.contract_number
1411: FROM IEX_CASES_ALL_B ica
1412: ,IEX_CASE_OBJECTS ico
1413: ,OKC_K_HEADERS_V okh
1414: WHERE ica.case_number = cp_case_number
1415: AND ica.cas_id = ico.cas_id
1416: AND ico.object_id = okh.id;
1417:

Line 1435: ,OKC_K_HEADERS_V okh

1431: FUNCTION get_case_total_value(p_case_number in varchar2) RETURN NUMBER AS
1432: CURSOR l_contract_csr(cp_case_number in varchar2) IS SELECT okh.id
1433: FROM IEX_CASES_ALL_B ica
1434: ,IEX_CASE_OBJECTS ico
1435: ,OKC_K_HEADERS_V okh
1436: WHERE ica.case_number = cp_case_number
1437: AND ica.cas_id = ico.cas_id
1438: AND ico.object_id = okh.id;
1439: