APPS.OKL_ARINTF_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 1149: OKC_K_HEADERS_ALL_B KHR,

1145: , TLD.INVOICE_FORMAT_LINE_TYPE INVOICE_LINE_TYPE -- Bug 7045347
1146: FROM OKL_TXD_AR_LN_DTLS_B TLD,
1147: OKL_TXL_AR_INV_LNS_V TIL,
1148: OKL_TRX_AR_INVOICES_V TAI,
1149: OKC_K_HEADERS_ALL_B KHR,
1150: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1151: -- OKC_K_LINES_V KLE,
1152: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1153: OKL_STRM_TYPE_V STY,

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

1476: n NUMBER; -- rmunjulu R12 Fixes
1477: l_creation_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
1478:
1479: -- gboomina added for bug 7513216 - start
1480: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
1481: is
1482: select id from okc_k_headers_all_b
1483: where contract_number = p_contract_number;
1484: -- gboomina added for bug 7513216 - end

Line 1482: select id from okc_k_headers_all_b

1478:
1479: -- gboomina added for bug 7513216 - start
1480: cursor get_khr_id_csr (p_contract_number okc_k_headers_all_b.contract_number%type)
1481: is
1482: select id from okc_k_headers_all_b
1483: where contract_number = p_contract_number;
1484: -- gboomina added for bug 7513216 - end
1485: BEGIN
1486: