APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKC_K_HEADERS_B

Line 608: okc_k_headers_b chr

604: CURSOR c_synd IS
605: SELECT
606: 'SYNDICATION'
607: FROM
608: okc_k_headers_b chr
609: WHERE
610: EXISTS ( SELECT 'x' FROM okc_k_items cim
611: WHERE cim.object1_id1 = to_char(chr.id) AND
612: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

Line 615: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2

611: WHERE cim.object1_id1 = to_char(chr.id) AND
612: EXISTS ( SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
613: WHERE cle.lse_id = lse.id AND
614: lse.lty_code = 'SHARED' AND cle.id = cim.cle_id ) AND
615: EXISTS ( SELECT 'x' FROM okc_k_headers_b chr2
616: WHERE chr2.id = cim.dnz_chr_id AND
617: chr2.scs_code = 'SYNDICATION' AND
618: chr2.sts_code not in ('TERMINATED','ABANDONED') ) ) AND
619: chr.scs_code = 'LEASE' AND

Line 1960: FROM okc_k_headers_b

1956: j NUMBER := 0;
1957:
1958: CURSOR c_get_cur(cp_khr_id IN NUMBER) IS
1959: SELECT currency_code
1960: FROM okc_k_headers_b
1961: WHERE id = cp_khr_id;
1962:
1963: BEGIN
1964: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2535: FROM okc_k_headers_b

2531:
2532:
2533: CURSOR c_get_cur(cp_khr_id IN NUMBER) IS
2534: SELECT currency_code
2535: FROM okc_k_headers_b
2536: WHERE id = cp_khr_id;
2537:
2538: CURSOR c_get_freq_arr (c_req_id NUMBER
2539: ,c_kle_id NUMBER

Line 4681: FROM okc_k_headers_b

4677: l_ppd_amount NUMBER := 0;
4678:
4679: CURSOR l_kheaders_csr(cp_khr_id IN NUMBER) IS
4680: SELECT currency_code
4681: FROM okc_k_headers_b
4682: WHERE id = cp_khr_id;
4683:
4684: CURSOR c_req_details_csr (a_id NUMBER)
4685: IS

Line 5157: FROM okc_k_headers_b

5153:
5154:
5155: CURSOR l_kheaders_csr(cp_khr_id IN NUMBER) IS
5156: SELECT currency_code
5157: FROM okc_k_headers_b
5158: WHERE id = cp_khr_id;
5159:
5160: CURSOR l_qco_id_csr(cp_qte_id IN NUMBER
5161: ,cp_cfo_id IN NUMBER

Line 5646: FROM okc_k_headers_b

5642:
5643:
5644: CURSOR l_kheaders_csr(cp_khr_id IN NUMBER) IS
5645: SELECT currency_code
5646: FROM okc_k_headers_b
5647: WHERE id = cp_khr_id;
5648:
5649: CURSOR l_qco_id_csr(cp_qte_id IN NUMBER
5650: ,cp_cfo_id IN NUMBER

Line 6131: FROM okc_k_headers_b

6127: l_ppd_amount NUMBER := 0;
6128:
6129: CURSOR l_kheaders_csr(cp_khr_id IN NUMBER) IS
6130: SELECT currency_code
6131: FROM okc_k_headers_b
6132: WHERE id = cp_khr_id;
6133:
6134: CURSOR c_req_details_csr (a_id NUMBER)
6135: IS

Line 6959: from okc_k_headers_b

6955: l_xcav_tbl OKL_BPD_ADVANCED_CASH_APP_PVT.xcav_tbl_type;
6956: CURSOR c_get_k_number (c_id NUMBER)
6957: IS
6958: SELECT contract_number
6959: from okc_k_headers_b
6960: where id=c_id;
6961:
6962: CURSOR c_get_req_details(c_req_id NUMBER)
6963: IS

Line 7258: FROM OKC_K_HEADERS_B

7254:
7255:
7256: CURSOR c_contract_details(p_contract_id IN NUMBER) IS
7257: SELECT *
7258: FROM OKC_K_HEADERS_B
7259: WHERE ID = p_contract_id;
7260: l_contract_id NUMBER ;
7261:
7262: l_contract_rec okc_k_headers_b%rowtype;

Line 7262: l_contract_rec okc_k_headers_b%rowtype;

7258: FROM OKC_K_HEADERS_B
7259: WHERE ID = p_contract_id;
7260: l_contract_id NUMBER ;
7261:
7262: l_contract_rec okc_k_headers_b%rowtype;
7263: l_ppd_date DATE;
7264: l_ppd_amount NUMBER;
7265: l_new_start_date DATE;
7266: l_next_start_dt DATE;