APPS.OKL_CURE_RECON_PVT dependencies on OKC_K_HEADERS_B

Line 14: FROM okc_k_headers_b

10: FUNCTION get_factor_synd(p_khr_id IN NUMBER) RETURN VARCHAR2 IS
11:
12: CURSOR c_synd IS
13: SELECT scs_code
14: FROM okc_k_headers_b
15: WHERE scs_code = 'SYNDICATION'
16: AND id = p_khr_id;
17:
18: CURSOR c_fact IS

Line 752: FROM okc_k_headers_b

748:
749: -- to get inventory_org_id bug 4890024 begin
750: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
751: SELECT NVL(inv_organization_id, -99)
752: FROM okc_k_headers_b
753: WHERE id = p_contract_id;
754:
755: BEGIN
756: -- Set API savepoint

Line 919: ,okc_k_headers_b chr

915: ,chr.conversion_rate conversion_rate
916: ,chr.conversion_rate_date conversion_rate_date
917: ,chr.authoring_org_id org_id
918: FROM okl_cure_amounts cam
919: ,okc_k_headers_b chr
920: WHERE chr.id = cam.chr_id
921: AND cam.cure_amount_id = p_cam_id;
922:
923: -- vdamerla Fix issue where the cure streams are not being processed by

Line 1995: okc_k_headers_b chr

1991: ,chr.scs_code scs_code
1992: FROM okc_contacts ct,
1993: okc_contact_sources csrc,
1994: okc_k_party_roles_b pty,
1995: okc_k_headers_b chr
1996: WHERE ct.cpl_id = pty.id
1997: AND ct.cro_code = csrc.cro_code
1998: AND ct.jtot_object1_code = csrc.jtot_object_code
1999: AND ct.dnz_chr_id = chr.id

Line 2013: FROM okc_k_headers_b

2009:
2010: CURSOR custBillTo_csr (p_contract_id IN NUMBER)
2011: IS
2012: SELECT bill_to_site_use_id cust_acct_site_id
2013: FROM okc_k_headers_b
2014: WHERE id = p_contract_id;
2015:
2016: l_custBillTo_rec custBillTo_csr%ROWTYPE;
2017:

Line 2024: from OKC_K_HEADERS_b

2020:
2021: cursor c_get_contract_currency (l_khr_id IN NUMBER)
2022: IS
2023: select currency_code
2024: from OKC_K_HEADERS_b
2025: where id =l_khr_id;
2026:
2027: CURSOR curr_csr (l_khr_id NUMBER)
2028: IS

Line 2039: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;

2035: l_functional_currency okl_trx_contracts.currency_code%TYPE;
2036: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
2037: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
2038: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
2039: l_contract_currency OKC_K_HEADERS_b.currency_code%TYPE;
2040:
2041: next_row integer;
2042:
2043: CURSOR c_get_accounting(p_cam_id IN NUMBER)

Line 2063: l_khr_id okc_k_headers_b.id%TYPE;

2059: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
2060: l_sty_id okl_txl_ar_inv_lns_b.sty_id%TYPE;
2061: l_try_id okl_trx_ar_invoices_b.try_id%TYPE;
2062: l_line_id okl_txd_ar_ln_dtls_b.id%TYPE;
2063: l_khr_id okc_k_headers_b.id%TYPE;
2064: l_date_invoiced okl_trx_ar_invoices_b.date_invoiced%TYPE;
2065: l_amount okl_trx_ar_invoices_b.amount%TYPE;
2066:
2067: CURSOR get_product_id(p_cam_id IN NUMBER)

Line 2074: okc_k_headers_b okc -- Bug# 4622198

2070: ,okl.id
2071: ,okc.scs_code -- Bug# 4622198
2072: FROM okl_k_headers okl,
2073: okl_cure_amounts cam,
2074: okc_k_headers_b okc -- Bug# 4622198
2075: WHERE okc.id = okl.id -- Bug# 4622198
2076: and okl.id = cam.chr_id
2077: and cam.cure_amount_id =p_cam_id;
2078:

Line 2115: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;

2111: --Bug# 4622198 :For special accounting treatment - START
2112:
2113: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
2114: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
2115: l_scs_code okc_k_headers_b.SCS_CODE%TYPE;
2116:
2117: --Bug# 4622198 :For special accounting treatment - END
2118:
2119: BEGIN