APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 497: FROM okc_k_headers_b hdr, okc_statuses_b status

493: AND date_terminated <= SYSDATE;
494:
495: CURSOR cancel_cntr IS
496: SELECT '1'
497: FROM okc_k_headers_b hdr, okc_statuses_b status
498: WHERE hdr.id = p_chr_id
499: AND hdr.sts_code = status.code
500: AND status.ste_code = 'CANCELLED';
501: */

Line 561: FROM okc_statuses_b

557: WHERE id = p_chr_id;
558:
559: CURSOR c_sts(p_code IN VARCHAR2) IS
560: SELECT ste_code
561: FROM okc_statuses_b
562: WHERE code = p_code;
563:
564: CURSOR c_class(p_scs_code IN VARCHAR2) IS
565: SELECT cls_code