eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INS_QUOTE_PVT dependencies on OKC_STATUSES_B

Line 571: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

567: ) RETURN VARCHAR2 IS
568: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
569: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
570: SELECT STE_CODE
571: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
572: WHERE KHR.ID = p_khr_id
573: AND KHR.STS_CODE = OST.CODE ;
574:
575: BEGIN

Line 2495: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

2491: l_status VARCHAR2(80);
2492: --p_contract_status VARCHAR2(1):= '?';
2493: CURSOR okc_k_status_csr IS
2494: SELECT STE_CODE
2495: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
2496: WHERE KHR.ID = p_khr_id
2497: AND KHR.STS_CODE = OST.CODE ;
2498:
2499:

Line 2514: 'OKC_STATUSES_B');

2510: 'ste_code',
2511: g_child_table_token ,
2512: 'OKC_K_HEADERS_V',
2513: g_parent_table_token ,
2514: 'OKC_STATUSES_B');
2515: END IF;
2516: CLOSE okc_k_status_csr ;
2517: EXCEPTION
2518: WHEN OTHERS THEN

Line 6077: ,OKC_STATUSES_B OSTS

6073: ,OKHB.CONTRACT_NUMBER
6074: FROM OKC_K_HEADERS_B OKHB
6075: ,OKL_INS_POLICIES_B IPY
6076: ,OKL_TRX_CONTRACTS CTRX
6077: ,OKC_STATUSES_B OSTS
6078: WHERE OKHB.ID = IPY.KHR_ID
6079: AND OKHB.ID = CTRX.KHR_ID
6080: AND OKHB.STS_CODE = OSTS.CODE
6081: AND OSTS.STE_CODE = 'ACTIVE'