55:
56: CURSOR c_app
57: IS
58: select a.application_id
59: from FND_APPLICATION a
60: where APPLICATION_SHORT_NAME = 'OKL'
61: ;
62:
63: /*
360:
361: CURSOR c_app
362: IS
363: select a.application_id
364: from FND_APPLICATION a
365: where APPLICATION_SHORT_NAME = 'OKL'
366: ;
367:
368: BEGIN
1365: CURSOR l_khr_line_amt_csr(cp_invoice_id NUMBER, cp_khr_id NUMBER) IS
1366: SELECT sum(lin.amount) khr_line_amount
1367: FROM ap_invoice_lines_all lin
1368: ,okl_txl_ap_inv_lns_all_b tpl
1369: ,fnd_application app
1370: WHERE lin.application_id = app.application_id
1371: AND app.application_short_name = 'OKL'
1372: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
1373: AND tpl.id = TO_NUMBER(lin.reference_key1)