APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKC_K_HEADERS_B

Line 708: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

704: i NUMBER := 0;
705: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
706: lv_sts_code OKC_K_LINES_B.STS_CODE%TYPE;
707: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
708: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
709:
710: -- Cursor to Know asset has serial number
711: -- RMUNJULU 24-JAN-03 2759726 Taken out the line status check
712: -- and check line sts same as header sts

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

720: okc_line_styles_b lse_inst,
721: okc_k_lines_b cle_inst,
722: okc_line_styles_b lse_fin,
723: okc_k_lines_b cle_fin,
724: okc_k_headers_b khr -- RMUNJULU 24-JAN-03 2759726 Added
725: WHERE cle_fin.cle_id is null
726: -- AND cle_fin.sts_code = 'BOOKED' -- RMUNJULU 24-JAN-03 2759726 Removed
727: AND cle_fin.chr_id = khr.id -- RMUNJULU 24-JAN-03 2759726 Added
728: AND cle_fin.sts_code = khr.sts_code -- RMUNJULU 24-JAN-03 2759726 Added

Line 755: okc_k_headers_b chr,

751: SELECT lse.lty_code,
752: cle.sts_code,
753: chr.contract_number
754: FROM okc_k_lines_b cle,
755: okc_k_headers_b chr,
756: okc_line_styles_b lse
757: WHERE cle.id = p_asset_line
758: AND cle.lse_id = lse.id
759: AND cle.dnz_chr_id = chr.id;

Line 1021: FROM OKC_K_HEADERS_B CHR

1017: -- RMUNJULU 3078988
1018: -- Returns if Accrual for contract till accrue till date has NOT been run
1019: CURSOR check_accrual_csr(p_chr_id NUMBER, p_accrue_till_date DATE) IS
1020: SELECT 'Y'
1021: FROM OKC_K_HEADERS_B CHR
1022: WHERE id = p_chr_id
1023: AND EXISTS (
1024: SELECT 1
1025: FROM OKL_STRM_TYPE_B sty,

Line 1229: FROM OKC_K_HEADERS_B CHR

1225: -- RMUNJULU 3061751 Added for SERVICE_K_INTEGRATION
1226: -- Get Service K details
1227: CURSOR get_service_k_dtls_csr(p_service_id IN NUMBER) IS
1228: SELECT CHR.contract_number
1229: FROM OKC_K_HEADERS_B CHR
1230: WHERE CHR.id = p_service_id;
1231:
1232: -- rmunjulu EDAT
1233: l_claims_exists VARCHAR2(3);

Line 1278: FROM Okc_K_Headers_b

1274: -- rmunjulu 6795295 get contract details
1275: CURSOR k_details_csr (l_khr_id IN NUMBER) IS
1276: SELECT sts_code,
1277: org_id
1278: FROM Okc_K_Headers_b
1279: WHERE id = l_khr_id;
1280:
1281: -- rmunjulu 6795295 get concurrent details
1282: CURSOR conc_details_csr (l_org_id IN NUMBER) IS

Line 3959: FROM OKC_K_HEADERS_B chr

3955: CURSOR validate_chr_id_csr(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
3956: SELECT 1
3957: FROM DUAL
3958: WHERE EXISTS (SELECT '1'
3959: FROM OKC_K_HEADERS_B chr
3960: WHERE chr.id = p_dnz_chr_id
3961: AND scs_code = G_LEASE_SCS_CODE);
3962: --AND sts_code = 'BOOKED');
3963: