APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_HEADERS_V

Line 222: FROM okc_k_headers_v CHR, okl_k_headers khr

218: x_batch_number NUMBER;
219:
220: CURSOR l_dltype_csr (chrid NUMBER) IS
221: SELECT khr.deal_type
222: FROM okc_k_headers_v CHR, okl_k_headers khr
223: WHERE CHR.ID = khr.ID AND CHR.ID = chrid;
224:
225: l_dltype_rec l_dltype_csr%ROWTYPE;
226:

Line 1041: FROM okc_k_headers_v

1037:
1038: CURSOR l_sts_csr (chrid NUMBER) IS
1039: SELECT sts_code,
1040: NVL (orig_system_source_code, 'XXX') src_code
1041: FROM okc_k_headers_v
1042: WHERE ID = chrid;
1043:
1044: l_sts_rec l_sts_csr%ROWTYPE;
1045: BEGIN

Line 1236: FROM okc_k_headers_v

1232:
1233: CURSOR l_sts_csr (chrid NUMBER) IS
1234: SELECT sts_code,
1235: NVL (orig_system_source_code, 'XXX') src_code
1236: FROM okc_k_headers_v
1237: WHERE ID = chrid;
1238:
1239: l_sts_rec l_sts_csr%ROWTYPE;
1240:

Line 1611: FROM okc_k_headers_v

1607:
1608: CURSOR l_sts_csr (chrid NUMBER) IS
1609: SELECT sts_code,
1610: NVL (orig_system_source_code, 'XXX') src_code
1611: FROM okc_k_headers_v
1612: WHERE ID = chrid;
1613:
1614: l_sts_rec l_sts_csr%ROWTYPE;
1615:

Line 2526: p_token1_value => 'OKC_K_HEADERS_V.ID'

2522: IF get_orig_sys_code%NOTFOUND THEN
2523: okl_api.set_message (p_app_name => g_app_name,
2524: p_msg_name => 'OKL_LLA_NO_MATCHING_RECORD',
2525: p_token1 => g_col_name_token,
2526: p_token1_value => 'OKC_K_HEADERS_V.ID'
2527: );
2528: RAISE okl_api.g_exception_error;
2529: END IF;
2530:

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

3248: pdt.ID pid,
3249: NVL (pdt.reporting_pdt_id, -1) report_pdt_id,
3250: CHR.currency_code currency_code,
3251: khr.term_duration term
3252: FROM okc_k_headers_v CHR, okl_k_headers khr, okl_products_v pdt
3253: WHERE khr.ID = CHR.ID AND CHR.ID = chrid AND khr.pdt_id = pdt.ID(+);
3254:
3255: l_hdr_rec l_hdr_csr%ROWTYPE;
3256: p_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;