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 582: FROM okc_k_vers_numbers

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

Line 774: FROM okc_k_vers_numbers

770: WHERE ID = p_chrv_rec.id;
771:
772: CURSOR version_csr(p_chr_id NUMBER) IS
773: SELECT to_char (major_version)||'.'||to_char(minor_version)
774: FROM okc_k_vers_numbers
775: WHERE chr_id=p_chr_id;
776:
777: Cursor l_status_csr Is
778: SELECT sts_code

Line 937: FROM okc_k_vers_numbers

933: WHERE chr_id = p_chrv_rec.id;
934:
935: Cursor l_cvm_csr Is
936: SELECT to_char(major_version)
937: FROM okc_k_vers_numbers
938: WHERE chr_id = p_chrv_rec.id;
939:
940: Cursor oie_csr Is
941: SELECT id

Line 1720: FROM okc_k_vers_numbers

1716: WHERE cle_id = p_clev_rec.id;
1717:
1718: Cursor l_cvm_csr(p_chr_id NUMBER) Is
1719: SELECT to_char(major_version)
1720: FROM okc_k_vers_numbers
1721: WHERE chr_id = p_chr_id;
1722:
1723:
1724: Cursor l_scrv_csr Is