APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_AR_INVOICES_B
Line 6384: FROM OKL_TRX_AR_INVOICES_B TAI
6380: -- Cursor to check if any records have been processed for billing
6381: CURSOR c_chk_billing_done ( p_cle_id IN NUMBER
6382: , p_chr_id IN NUMBER) IS
6383: SELECT 'Y' 6384: FROM OKL_TRX_AR_INVOICES_B TAI 6385: , OKL_TXL_AR_INV_LNS_B TXL
6386: WHERE TXL.TAI_ID = TAI.ID
6387: AND TXL.KLE_ID = p_cle_id -- subsidy cle id
6388: AND TAI.KHR_ID = p_chr_id