APPS.OKC_TERMINATE_PVT dependencies on OKC_STATUSES_V

Line 311: FROM okc_statuses_v sts

307: and v.in_process_yn='Y';
308:
309: CURSOR cur_sts_code (l_code varchar2) is
310: SELECT sts.ste_code,sts.meaning
311: FROM okc_statuses_v sts
312: WHERE sts.code = l_code;
313:
314: --Commeting Bug 4354983 Takintoy.
315: --SR check done in OKS_BILL_REC_PUB

Line 349: l_meaning okc_statuses_v.meaning%type;

345:
346: l_chg_request_in_process varchar2(1);
347:
348: l_status varchar2(30); -- Impact on status
349: l_meaning okc_statuses_v.meaning%type;
350:
351: l_return_status varchar2(1) := okc_api.g_ret_sts_success;
352:
353: BEGIN

Line 540: l_ste_code OKC_STATUSES_V.CODE%TYPE;

536:
537: rec_k_header OKC_CONTRACT_PUB.chrv_rec_type;
538: --
539: --
540: l_ste_code OKC_STATUSES_V.CODE%TYPE;
541:
542: CURSOR C_GET_STE_CODE(p_sts_code varchar2) IS
543: SELECT STE_CODE
544: FROM OKC_STATUSES_V

Line 544: FROM OKC_STATUSES_V

540: l_ste_code OKC_STATUSES_V.CODE%TYPE;
541:
542: CURSOR C_GET_STE_CODE(p_sts_code varchar2) IS
543: SELECT STE_CODE
544: FROM OKC_STATUSES_V
545: WHERE CODE = p_sts_code;
546: --
547:
548: CURSOR lock_lines is

Line 1153: FROM okc_statuses_v sts

1149:
1150: -- p_code changed from number to Varchar2
1151: CURSOR cur_sts_code(p_code VARCHAR2) is
1152: SELECT sts.ste_code,sts.meaning
1153: FROM okc_statuses_v sts
1154: WHERE sts.code = p_code;
1155: CURSOR cur_service_requests is
1156: SELECT 'x'
1157: FROM okx_incident_statuses_v xis,

Line 1169: l_meaning okc_statuses_v.meaning%type;

1165:
1166: l_chg_request_in_process varchar2(1);
1167:
1168: l_status varchar2(30) ; -- Impact on status
1169: l_meaning okc_statuses_v.meaning%type;
1170:
1171: l_return_status varchar2(1) := okc_api.g_ret_sts_success;
1172: l_dummy varchar2(1);
1173: