APPS.OKL_VP_TERMINATE_PVT dependencies on OKC_STATUSES_V

Line 40: FROM okc_statuses_v sts

36: AND v.in_process_yn='Y';
37:
38: CURSOR cur_sts_code (l_code varchar2) is
39: SELECT sts.ste_code,sts.meaning
40: FROM okc_statuses_v sts
41: WHERE sts.code = l_code;
42:
43: CURSOR cur_service_requests is
44: SELECT 'x'

Line 74: l_meaning okc_statuses_v.meaning%TYPE;

70:
71: l_chg_request_in_process VARCHAR2(1);
72:
73: l_status varchar2(30); -- Impact on status
74: l_meaning okc_statuses_v.meaning%TYPE;
75:
76: l_return_status varchar2(1) := okc_api.g_ret_sts_success;
77: l_api_name CONSTANT VARCHAR2(30) := 'validate_chr';
78: