APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 3032: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b

3028: l_count NUMBER := 0;
3029: l_row_notfound BOOLEAN;
3030: l_token VARCHAR2(2000);
3031:
3032: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b
3033: -- instead of okl_trx_ap_invoices_b. changes made as part of OKLR12B
3034: -- disbursements project
3035: CURSOR l_prefund_csr( chrId NUMBER ) IS
3036: SELECT 'Y'

Line 3038: ,okl_txl_ap_inv_lns_all_b tpl

3034: -- disbursements project
3035: CURSOR l_prefund_csr( chrId NUMBER ) IS
3036: SELECT 'Y'
3037: FROM okl_trx_ap_invoices_b hdr
3038: ,okl_txl_ap_inv_lns_all_b tpl
3039: WHERE hdr.funding_type_code = 'PREFUNDING'
3040: AND hdr.trx_status_code NOT IN ('APPROVED', 'PROCESSED', 'ERROR')
3041: AND hdr.id = tpl.tap_id
3042: AND tpl.khr_id = chrId;