APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 496: FROM okc_k_headers_b hdr, okc_statuses_b status

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

Line 560: FROM okc_statuses_b

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