APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 6297: FROM OKL_TRX_AR_INVOICES_V TRX

6293: CURSOR c_get_bill_stat( p_cle_id IN NUMBER,
6294: p_chr_id IN NUMBER) IS
6295: SELECT TRX.ID
6296: , TRX.DESCRIPTION
6297: FROM OKL_TRX_AR_INVOICES_V TRX
6298: , OKL_TXL_AR_INV_LNS_B TIL
6299: WHERE TIL.TAI_ID = TRX.ID
6300: AND TIL.KLE_ID = p_cle_id -- subsidy cle id
6301: AND TRX.KHR_ID = p_chr_id

Line 6339: , OKL_TRX_AR_INVOICES_V TAI

6335: -- varangan - Bug#5588871 - Modified - End
6336: , ARL.AMOUNT_DUE_ORIGINAL invoice_amount
6337: FROM OKL_BPD_AR_INV_LINES_V ARL
6338: , OKL_TXL_AR_INV_LNS_V TIL
6339: , OKL_TRX_AR_INVOICES_V TAI
6340: WHERE
6341: TIL.KLE_ID = p_cle_id -- < SUBSIDY CLE ID >
6342: AND TAI.ID = TIL.TAI_ID
6343: AND TAI.KHR_ID = p_chr_id

Line 6375: , OKL_TRX_AR_INVOICES_V TAI

6371: til.line_number line_number,
6372: til.inv_receiv_line_code inv_receiv_line_code
6373: , til.bank_acct_id bank_acct_id
6374: FROM OKL_TXL_AR_INV_LNS_V TIL
6375: , OKL_TRX_AR_INVOICES_V TAI
6376: WHERE TIL.KLE_ID = p_cle_id -- < SUBSIDY CLE ID >
6377: AND TAI.ID = TIL.TAI_ID
6378: AND TAI.KHR_ID = p_chr_id;
6379: