DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on OKC_STATUSES_V

Line 2728: FROM OKC_STATUSES_V

2724:
2725: -- Cursor to get the ste code
2726: CURSOR get_old_ste_code_csr(p_sts_code VARCHAR2) IS
2727: SELECT STE_CODE
2728: FROM OKC_STATUSES_V
2729: WHERE CODE = p_sts_code;
2730:
2731: -- Cursor to get contract details
2732: CURSOR k_header_csr IS

Line 2755: FROM OKC_STATUSES_V

2751:
2752: -- Cursor to get the meaning of the sts_code passed
2753: CURSOR k_sts_code_meaning_csr( p_sts_code IN VARCHAR2) IS
2754: SELECT meaning
2755: FROM OKC_STATUSES_V
2756: WHERE code = p_sts_code;
2757:
2758:
2759: rec_k_header k_header_csr%ROWTYPE;

Line 2765: l_ste_code OKC_STATUSES_V.CODE%TYPE;

2761: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2762: --l_status_code VARCHAR2(30);
2763: i NUMBER;
2764: l_scs_code OKC_SUBCLASSES_V.code%TYPE;
2765: l_ste_code OKC_STATUSES_V.CODE%TYPE;
2766: lp_chrv_rec chrv_rec_type;
2767: lx_chrv_rec chrv_rec_type;
2768: lp_clev_tbl clev_tbl_type;
2769: lx_clev_tbl clev_tbl_type;