APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TRX_AP_INVOICES_B

Line 3190: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B

3186: l_row_notfound BOOLEAN;
3187: l_token VARCHAR2(2000);
3188:
3189: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b
3190: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B
3191: -- disbursements project
3192: CURSOR l_prefund_csr( chrId NUMBER ) IS
3193: SELECT 'Y'
3194: FROM okl_trx_ap_invoices_b hdr

Line 3194: FROM okl_trx_ap_invoices_b hdr

3190: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B
3191: -- disbursements project
3192: CURSOR l_prefund_csr( chrId NUMBER ) IS
3193: SELECT 'Y'
3194: FROM okl_trx_ap_invoices_b hdr
3195: ,okl_txl_ap_inv_lns_all_b tpl
3196: WHERE hdr.funding_type_code = 'PREFUNDING'
3197: AND hdr.trx_status_code NOT IN ('APPROVED', 'PROCESSED', 'ERROR')
3198: AND hdr.id = tpl.tap_id

Line 13609: from okl_trx_ap_invoices_b trx

13605:
13606: CURSOR l_pre_funding_csr(p_chr_id NUMBER)
13607: IS
13608: select NVL(SUM(trx.amount),0) amount
13609: from okl_trx_ap_invoices_b trx
13610: ,okl_txl_ap_inv_lns_all_b txl
13611: where trx.id = txl.tap_id
13612: and trx.funding_type_code = 'PREFUNDING'
13613: and trx.trx_status_code in ('APPROVED', 'PROCESSED')