APPS.OKC_RENEW_PVT dependencies on OKC_STATUSES_V

Line 313: FROM okc_statuses_v

309: WHERE id = p_chr_id;
310:
311: CURSOR cur_status(p_code IN VARCHAR2) IS
312: SELECT ste_code
313: FROM okc_statuses_v
314: WHERE code = p_code;
315:
316: BEGIN
317:

Line 485: FROM okc_statuses_v

481: WHERE id = p_renew_in_parameters_rec.p_contract_id;
482:
483: CURSOR cur_status(p_sts_code varchar2) is
484: SELECT ste_code,meaning
485: FROM okc_statuses_v
486: WHERE code = p_sts_code;
487:
488: CURSOR cur_uom is
489: SELECT 'x'

Line 509: l_meaning okc_statuses_v.meaning%TYPE;

505: AND rel.object1_id1 = qte.quote_header_id;
506: */
507:
508: l_status varchar2(30):='1';
509: l_meaning okc_statuses_v.meaning%TYPE;
510: l_dummy varchar2(1);
511: k_header_rec cur_k_header%rowtype;
512: -- qte_rec cur_qte%rowtype;
513: l_api_name Varchar2(30) := 'Validate';