APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 968: FROM okc_k_headers_all_b

964: p_khr_id IN NUMBER)
965: RETURN VARCHAR2 IS
966: CURSOR l_khr_status_csr IS
967: SELECT STS_CODE
968: FROM okc_k_headers_all_b
969: WHERE ID = p_khr_id;
970:
971: CURSOR l_get_booked_Astloc_csr IS
972: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,

Line 1082: FROM okc_k_headers_all_b

1078: p_khr_id IN NUMBER)
1079: RETURN NUMBER IS
1080: CURSOR l_khr_status_csr IS
1081: SELECT STS_CODE
1082: FROM okc_k_headers_all_b
1083: WHERE ID = p_khr_id;
1084:
1085: CURSOR l_get_booked_Astloc_csr IS
1086: SELECT psu.party_site_use_id

Line 1197: FROM okc_k_headers_all_b

1193: p_khr_id IN NUMBER)
1194: RETURN VARCHAR2 IS
1195: CURSOR l_khr_status_csr IS
1196: SELECT STS_CODE
1197: FROM okc_k_headers_all_b
1198: WHERE ID = p_khr_id;
1199:
1200: CURSOR l_get_booked_astnum_csr IS
1201: SELECT FAV.ASSET_NUMBER ASSETNUMBER

Line 1750: okc_k_headers_all_b chr

1746: FROM okl_party_payment_hdr vHdr,
1747: okl_party_payment_dtls vDtls,
1748: okc_k_lines_b cle,
1749: okl_k_lines kle,
1750: okc_k_headers_all_b chr
1751: WHERE vDtls.payment_hdr_id = vHdr.id
1752: AND vHdr.CLE_ID = cle.id
1753: AND vHdr.DNZ_CHR_ID = p_chr_id
1754: AND vHdr.PASSTHRU_TERM = 'BASE'

Line 1792: FROM okc_k_headers_all_b rbk_chr,

1788: CURSOR is_rbk_on_csr( p_khr_id IN NUMBER)
1789: IS
1790: SELECT 'Y' online_rebook_in_progress,
1791: orig_chr.id
1792: FROM okc_k_headers_all_b rbk_chr,
1793: okc_k_headers_all_b orig_chr,
1794: okl_trx_contracts_all trx
1795: WHERE rbk_chr.id = p_khr_id
1796: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'

Line 1793: okc_k_headers_all_b orig_chr,

1789: IS
1790: SELECT 'Y' online_rebook_in_progress,
1791: orig_chr.id
1792: FROM okc_k_headers_all_b rbk_chr,
1793: okc_k_headers_all_b orig_chr,
1794: okl_trx_contracts_all trx
1795: WHERE rbk_chr.id = p_khr_id
1796: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
1797: AND trx.khr_id_new = rbk_chr.id

Line 2019: FROM okc_k_headers_all_b

2015: FROM okl_sys_acct_opts;
2016:
2017: CURSOR l_chr_csr(p_chr_id IN NUMBER) IS
2018: SELECT contract_number
2019: FROM okc_k_headers_all_b
2020: WHERE id = p_chr_id;
2021:
2022: CURSOR l_rbk_chr_upg_csr(p_rbk_chr_id IN NUMBER)
2023: IS

Line 2032: l_contract_number okc_k_headers_all_b.contract_number%TYPE;

2028:
2029: l_chr_upgraded_yn VARCHAR2(1);
2030: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
2031: l_amort_inc_adj_rev_dt_yn okl_sys_acct_opts.amort_inc_adj_rev_dt_yn%TYPE;
2032: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
2033:
2034: BEGIN
2035: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2036: -- Call start_activity to create savepoint, check compatibility