APPS.OKC_CONTRACT_PVT dependencies on OKC_K_VERS_NUMBERS

Line 441: FROM okc_k_vers_numbers

437: l_version VARCHAR2(255);
438:
439: CURSOR version_csr(p_chr_id NUMBER) IS
440: SELECT to_char (major_version)||'.'||to_char(minor_version)
441: FROM okc_k_vers_numbers
442: WHERE chr_id=p_chr_id;
443:
444: BEGIN
445: -- initialize return status

Line 584: FROM okc_k_vers_numbers

580: WHERE ID = p_chrv_rec.id;
581:
582: CURSOR version_csr(p_chr_id NUMBER) IS
583: SELECT to_char (major_version)||'.'||to_char(minor_version)
584: FROM okc_k_vers_numbers
585: WHERE chr_id=p_chr_id;
586:
587: Cursor l_status_csr Is
588: SELECT sts_code

Line 805: FROM okc_k_vers_numbers

801: WHERE ID = p_chrv_rec.id;
802:
803: CURSOR version_csr(p_chr_id NUMBER) IS
804: SELECT to_char (major_version)||'.'||to_char(minor_version)
805: FROM okc_k_vers_numbers
806: WHERE chr_id=p_chr_id;
807:
808: Cursor l_status_csr Is
809: SELECT sts_code

Line 995: FROM okc_k_vers_numbers

991: WHERE chr_id = p_chrv_rec.id;
992:
993: Cursor l_cvm_csr Is
994: SELECT to_char(major_version)
995: FROM okc_k_vers_numbers
996: WHERE chr_id = p_chrv_rec.id;
997:
998: Cursor oie_csr Is
999: SELECT id

Line 1778: FROM okc_k_vers_numbers

1774: WHERE cle_id = p_clev_rec.id;
1775:
1776: Cursor l_cvm_csr(p_chr_id NUMBER) Is
1777: SELECT to_char(major_version)
1778: FROM okc_k_vers_numbers
1779: WHERE chr_id = p_chr_id;
1780:
1781:
1782: Cursor l_scrv_csr Is