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_AM_LEASE_TRMNT_PVT dependencies on OKC_STATUSES_V

Line 2844: FROM OKC_STATUSES_V

2840:
2841: -- Cursor to get the ste code
2842: CURSOR get_old_ste_code_csr(p_sts_code VARCHAR2) IS
2843: SELECT STE_CODE
2844: FROM OKC_STATUSES_V
2845: WHERE CODE = p_sts_code;
2846:
2847: -- Cursor to get contract details
2848: CURSOR k_header_csr IS

Line 2871: FROM OKC_STATUSES_V

2867:
2868: -- Cursor to get the meaning of the sts_code passed
2869: CURSOR k_sts_code_meaning_csr( p_sts_code IN VARCHAR2) IS
2870: SELECT meaning
2871: FROM OKC_STATUSES_V
2872: WHERE code = p_sts_code;
2873:
2874:
2875: rec_k_header k_header_csr%ROWTYPE;

Line 2881: l_ste_code OKC_STATUSES_V.CODE%TYPE;

2877: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2878: --l_status_code VARCHAR2(30);
2879: i NUMBER;
2880: l_scs_code OKC_SUBCLASSES_V.code%TYPE;
2881: l_ste_code OKC_STATUSES_V.CODE%TYPE;
2882: lp_chrv_rec chrv_rec_type;
2883: lx_chrv_rec chrv_rec_type;
2884: lp_clev_tbl clev_tbl_type;
2885: lx_clev_tbl clev_tbl_type;