APPS.OKL_CASH_APPL_RULES dependencies on OKC_K_HEADERS_ALL_B

Line 321: OKC_K_HEADERS_ALL_B CN,

317: select distinct(ST.KHR_ID) CONTRACT_ID ,
318: CN.CONTRACT_NUMBER CONTRACT_NUMBER ,
319: CN.START_DATE START_DATE
320: from
321: OKC_K_HEADERS_ALL_B CN,
322: OKL_CNSLD_AR_STRMS_B ST,
323: OKL_CNSLD_AR_HDRS_B HD,
324: HZ_CUST_ACCOUNTS CA,
325: OKL_CNSLD_AR_LINES_B LN,

Line 350: OKC_K_HEADERS_ALL_B CN,

346: -- get a contract id if not known
347: CURSOR c_get_contract_id (cp_contract_num IN VARCHAR2) IS
348: select ST.KHR_ID CONTRACT_ID
349: from
350: OKC_K_HEADERS_ALL_B CN,
351: OKL_CNSLD_AR_STRMS_B ST,
352: AR_PAYMENT_SCHEDULES_ALL PS
353: WHERE PS.CLASS IN ('INV', 'CM')
354: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID

Line 2201: ,p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE DEFAULT NULL

2197: ,x_msg_count OUT NOCOPY NUMBER
2198: ,x_msg_data OUT NOCOPY VARCHAR2
2199: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
2200: ,p_ar_inv_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL
2201: ,p_contract_id IN OKC_K_HEADERS_ALL_B.ID%TYPE DEFAULT NULL
2202: ,p_rcpt_rec IN rcpt_rec_type
2203: ,x_cash_receipt_id OUT NOCOPY NUMBER
2204: ) IS
2205: