APPS.OKC_CONTRACT_PVT dependencies on OKC_STATUSES_B

Line 598: FROM okc_statuses_b

594: WHERE ID = p_chrv_rec.id;
595:
596: CURSOR ste_code_csr(p_status_code VARCHAR2) IS
597: SELECT ste_code
598: FROM okc_statuses_b
599: WHERE code=p_status_code;
600:
601: BEGIN
602: -- if the update is not a restricted update (restricted_update <> 'Y'),

Line 819: FROM okc_statuses_b

815: WHERE ID = p_chrv_rec.id;
816:
817: CURSOR ste_code_csr(p_status_code VARCHAR2) IS
818: SELECT ste_code
819: FROM okc_statuses_b
820: WHERE code=p_status_code;
821:
822: BEGIN
823: -- if the update is not a restricted update (restricted_update <> 'Y'),

Line 1008: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header

1004: SELECT id, object_version_number, dnz_chr_id
1005: FROM okc_k_sales_credits
1006: WHERE chr_id = p_chrv_rec.id;
1007: Cursor cur_status Is
1008: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header
1009: where status.code = header.sts_code
1010: AND header.id = p_chrv_rec.id;
1011:
1012: