APPS.OKC_CONTRACT_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 578: FROM okc_k_headers_all_b

574: SELECT currency_code
575: --npalepu 26-10-2005 modified for bug # 4691662.
576: --Replaced table okc_k_headers_b with headers_All_b table
577: /* FROM okc_k_headers_b */
578: FROM okc_k_headers_all_b
579: --end npalepu
580: WHERE ID = p_chrv_rec.id;
581:
582: CURSOR version_csr(p_chr_id NUMBER) IS

Line 592: FROM okc_k_headers_all_b

588: SELECT sts_code
589: --npalepu 26-10-2005 modified for bug # 4691662.
590: --Replaced table okc_k_headers_b with headers_All_b table
591: /* FROM okc_k_headers_b */
592: FROM okc_k_headers_all_b
593: --end npalepu
594: WHERE ID = p_chrv_rec.id;
595:
596: CURSOR ste_code_csr(p_status_code VARCHAR2) IS

Line 799: FROM okc_k_headers_all_b

795: SELECT currency_code
796: --npalepu 26-10-2005 modified for bug # 4691662.
797: --Replaced table okc_k_headers_b with headers_All_b table
798: /* FROM okc_k_headers_b */
799: FROM okc_k_headers_all_b
800: --end npalepu
801: WHERE ID = p_chrv_rec.id;
802:
803: CURSOR version_csr(p_chr_id NUMBER) IS

Line 813: FROM okc_k_headers_all_b

809: SELECT sts_code
810: --npalepu 26-10-2005 modified for bug # 4691662.
811: --Replaced table okc_k_headers_b with headers_All_b table
812: /* FROM okc_k_headers_b */
813: FROM okc_k_headers_all_b
814: --end npalepu
815: WHERE ID = p_chrv_rec.id;
816:
817: CURSOR ste_code_csr(p_status_code VARCHAR2) IS

Line 1548: FROM okc_k_headers_all_b

1544: SELECT contract_number,contract_number_modifier
1545: --npalepu 26-10-2005 modified for bug # 4691662.
1546: --Replaced table okc_k_headers_b with headers_All_b table
1547: /* FROM okc_k_headers_b */
1548: FROM okc_k_headers_all_b
1549: --end npalepu
1550: where id = p_id;
1551: BEGIN
1552: -- check whether the contract is updateable or not

Line 4244: FROM OKC_K_HEADERS_ALL_B

4240: SELECT sts_code, scs_code
4241: --npalepu 26-10-2005 modified for bug # 4691662.
4242: --Replaced table okc_k_headers_b with headers_All_b table
4243: /* FROM OKC_K_HEADERS_B */
4244: FROM OKC_K_HEADERS_ALL_B
4245: --end npalepu
4246: WHERE id = p_chr_id;
4247:
4248: Cursor l_astv_csr Is

Line 4801: okc_k_headers_all_b okhb

4797:
4798: Cursor get_lines_id(p_id number) IS
4799: select oklb.id,oklb.price_negotiated
4800: from okc_k_lines_b oklb,
4801: okc_k_headers_all_b okhb
4802: where oklb.chr_id = okhb.id
4803: and okhb.id = p_id
4804: and oklb.lse_id in (1,12,14,19,46);
4805: