APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_HEADERS_V

Line 316: FROM okc_k_headers_v CHR, okl_k_headers khr

312: x_batch_number NUMBER;
313:
314: CURSOR l_dltype_csr (chrid NUMBER) IS
315: SELECT khr.deal_type
316: FROM okc_k_headers_v CHR, okl_k_headers khr
317: WHERE CHR.ID = khr.ID AND CHR.ID = chrid;
318:
319: l_dltype_rec l_dltype_csr%ROWTYPE;
320:

Line 1341: FROM okc_k_headers_v

1337:
1338: CURSOR l_sts_csr (chrid NUMBER) IS
1339: SELECT sts_code,
1340: NVL (orig_system_source_code, 'XXX') src_code
1341: FROM okc_k_headers_v
1342: WHERE ID = chrid;
1343:
1344: l_sts_rec l_sts_csr%ROWTYPE;
1345: BEGIN

Line 1538: FROM okc_k_headers_v

1534:
1535: CURSOR l_sts_csr (chrid NUMBER) IS
1536: SELECT sts_code,
1537: NVL (orig_system_source_code, 'XXX') src_code
1538: FROM okc_k_headers_v
1539: WHERE ID = chrid;
1540:
1541: l_sts_rec l_sts_csr%ROWTYPE;
1542:

Line 1915: FROM okc_k_headers_v

1911:
1912: CURSOR l_sts_csr (chrid NUMBER) IS
1913: SELECT sts_code,
1914: NVL (orig_system_source_code, 'XXX') src_code
1915: FROM okc_k_headers_v
1916: WHERE ID = chrid;
1917:
1918: l_sts_rec l_sts_csr%ROWTYPE;
1919:

Line 2829: p_token1_value => 'OKC_K_HEADERS_V.ID'

2825: IF get_orig_sys_code%NOTFOUND THEN
2826: okl_api.set_message (p_app_name => g_app_name,
2827: p_msg_name => 'OKL_LLA_NO_MATCHING_RECORD',
2828: p_token1 => g_col_name_token,
2829: p_token1_value => 'OKC_K_HEADERS_V.ID'
2830: );
2831: RAISE okl_api.g_exception_error;
2832: END IF;
2833:

Line 3555: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt

3551: pdt.ID pid,
3552: NVL (pdt.reporting_pdt_id, -1) report_pdt_id,
3553: CHR.currency_code currency_code,
3554: khr.term_duration term
3555: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt
3556: WHERE khr.ID = CHR.ID AND CHR.ID = chrid AND khr.pdt_id = pdt.ID(+);
3557:
3558: l_hdr_rec l_hdr_csr%ROWTYPE;
3559: p_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;