APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKC_K_HEADERS_B

Line 719: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

715: i NUMBER := 0;
716: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
717: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;
718: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
719: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
720:
721: -- Cursor to Know asset has serial number
722: -- RMUNJULU 24-JAN-03 2759726 Taken out the line status check
723: -- and check line sts same as header sts

Line 735: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added

731: okc_line_styles_b lse_inst,
732: okc_k_lines_b cle_inst,
733: okc_line_styles_b lse_fin,
734: okc_k_lines_b cle_fin,
735: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
736: WHERE cle_fin.cle_id is null
737: -- AND cle_fin.sts_code = 'BOOKED' -- RMUNJULU 24-JAN-03 2759726 Removed
738: AND cle_fin.chr_id = khr.id -- RMUNJULU 24-JAN-03 2759726 Added
739: AND cle_fin.sts_code = khr.sts_code -- RMUNJULU 24-JAN-03 2759726 Added

Line 766: okc_k_headers_b chr,

762: SELECT lse.lty_code,
763: cle.sts_code,
764: chr.contract_number
765: FROM okc_k_lines_b cle,
766: okc_k_headers_b chr,
767: okc_line_styles_b lse
768: WHERE cle.id = p_asset_line
769: AND cle.lse_id = lse.id
770: AND cle.dnz_chr_id = chr.id;

Line 1033: FROM OKC_K_HEADERS_B CHR

1029: -- RMUNJULU 3078988
1030: -- Returns if Accrual for contract till accrue till date has NOT been run
1031: CURSOR check_accrual_csr(p_chr_id NUMBER, p_accrue_till_date DATE) IS
1032: SELECT 'Y'
1033: FROM OKC_K_HEADERS_B CHR
1034: WHERE id = p_chr_id
1035: AND EXISTS (
1036: SELECT 1
1037: FROM OKL_STRM_TYPE_B sty,

Line 1241: FROM OKC_K_HEADERS_B CHR

1237: -- RMUNJULU 3061751 Added for SERVICE_K_INTEGRATION
1238: -- Get Service K details
1239: CURSOR get_service_k_dtls_csr(p_service_id IN NUMBER) IS
1240: SELECT CHR.contract_number
1241: FROM OKC_K_HEADERS_B CHR
1242: WHERE CHR.id = p_service_id;
1243:
1244: -- rmunjulu EDAT
1245: l_claims_exists VARCHAR2(3);

Line 1290: FROM Okc_K_Headers_b

1286: -- rmunjulu 6795295 get contract details
1287: CURSOR k_details_csr (l_khr_id IN NUMBER) IS
1288: SELECT sts_code,
1289: org_id
1290: FROM Okc_K_Headers_b
1291: WHERE id = l_khr_id;
1292:
1293: -- rmunjulu 6795295 get concurrent details
1294: CURSOR conc_details_csr (l_org_id IN NUMBER) IS

Line 4169: FROM OKC_K_HEADERS_B chr

4165: CURSOR validate_chr_id_csr(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4166: SELECT 1
4167: FROM DUAL
4168: WHERE EXISTS (SELECT '1'
4169: FROM OKC_K_HEADERS_B chr
4170: WHERE chr.id = p_dnz_chr_id
4171: AND scs_code = G_LEASE_SCS_CODE);
4172: --AND sts_code = 'BOOKED');
4173: