APPS.OKL_ARINTF_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 2001: OKC_K_HEADERS_ALL_B KHR,

1997: , TIL.ID TIL_ID -- Bug# 12617408
1998: FROM OKL_TXD_AR_LN_DTLS_B TLD,
1999: OKL_TXL_AR_INV_LNS_V TIL,
2000: OKL_TRX_AR_INVOICES_V TAI,
2001: OKC_K_HEADERS_ALL_B KHR,
2002: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2003: -- OKC_K_LINES_V KLE,
2004: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2005: OKL_STRM_TYPE_V STY,

Line 2446: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)

2442: n NUMBER; -- rmunjulu R12 Fixes
2443: l_creation_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
2444:
2445: -- gboomina added for bug 7513216 - start
2446: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
2447: is
2448: select id from okc_k_headers_all_b
2449: where contract_number = p_contract_number;
2450: -- gboomina added for bug 7513216 - end

Line 2448: select id from okc_k_headers_all_b

2444:
2445: -- gboomina added for bug 7513216 - start
2446: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
2447: is
2448: select id from okc_k_headers_all_b
2449: where contract_number = p_contract_number;
2450: -- gboomina added for bug 7513216 - end
2451:
2452: --nikshah added for bug 9223230 start