DBA Data[Home] [Help]

APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on FND_APPLICATION

Line 59: from FND_APPLICATION a

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: /*

Line 364: from FND_APPLICATION a

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

Line 1369: ,fnd_application app

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)