APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 134: , OKC_K_HEADERS_B CHR

130: SELECT LAB.REFERENCE_NUMBER LSE_APP
131: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
132: FROM OKL_LEASE_APPLICATIONS_B LAB
133: , OKL_LEASE_QUOTES_B QTE
134: , OKC_K_HEADERS_B CHR
135: , OKC_STATUSES_V CSTS
136: WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID
137: AND QTE.PARENT_OBJECT_CODE = 'LEASEOPP'
138: AND LAB.APPLICATION_STATUS = 'CONV-K'

Line 154: , OKC_K_HEADERS_B CHR

150: , LOP.REFERENCE_NUMBER LSE_OPP
151: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
152: FROM OKL_LEASE_QUOTES_B LSQ
153: , OKL_LEASE_OPPORTUNITIES_B LOP
154: , OKC_K_HEADERS_B CHR
155: , OKC_STATUSES_V CSTS
156: WHERE CHR.ORIG_SYSTEM_ID1 = LOP.ID
157: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
158: AND CSTS.CODE = CHR.STS_CODE

Line 946: FROM okc_k_headers_b chr,

942: SELECT end_date,
943: term_duration
944: INTO l_contract_end_date,
945: l_term
946: FROM okc_k_headers_b chr,
947: okl_k_headers khr
948: WHERE chr.id = p_chr_id
949: AND chr.id = khr.id;
950: SELECT DECODE(p_payment_frequency, 'A', 12, 'S', 6, 'Q', 3, 'M', 1)

Line 1518: FROM okc_k_headers_b

1514: WHERE id = p_cle_id;
1515:
1516: SELECT currency_code
1517: INTO l_currency_code
1518: FROM okc_k_headers_b
1519: WHERE id = p_chr_id;
1520:
1521: FOR l_fee_srv_asset_rec IN c_fee_srv_asset_dtls(p_qte_fee_srv_id) loop
1522: i:=i+1;

Line 2449: FROM okc_k_headers_b

2445: SELECT start_date,
2446: end_date
2447: INTO l_k_effective_from,
2448: l_k_effective_to
2449: FROM okc_k_headers_b
2450: WHERE id = p_chr_id;
2451: FOR l_quote_fee_rec IN c_get_fee_dtls(p_quote_id)LOOP
2452: -- placeholder recurring expense
2453: IF l_quote_fee_rec.fee_type IN ('ABSORBED' , 'FINANCED') THEN

Line 4764: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;

4760: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4761: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
4762:
4763: -- Added by rravikir (Bug 5142890)
4764: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;
4765: CURSOR l_qcl_csr IS
4766: SELECT qcl.id
4767: FROM OKC_QA_CHECK_LISTS_TL qcl,
4768: OKC_QA_CHECK_LISTS_B qclv

Line 5044: FROM okc_k_headers_b

5040: l_contract_number VARCHAR2(240);
5041: --cursor to check existance of contract number
5042: CURSOR chk_cntrct_exists(lc_contract_number IN VARCHAR2 )IS
5043: SELECT 'Y'
5044: FROM okc_k_headers_b
5045: where contract_number = lc_contract_number;
5046: --cursor to count the contract numbers which are like the one we want to create
5047: CURSOR chk_count IS
5048: SELECT count(1)

Line 5049: FROM okc_k_headers_b

5045: where contract_number = lc_contract_number;
5046: --cursor to count the contract numbers which are like the one we want to create
5047: CURSOR chk_count IS
5048: SELECT count(1)
5049: FROM okc_k_headers_b
5050: WHERE contract_number like p_contract_number || '%';
5051:
5052: CURSOR c_get_leaseopp IS
5053: SELECT parent_object_id