APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 49: G_AR_LINES_SOURCE CONSTANT VARCHAR2(30) := 'OKL_TXL_AR_INV_LNS_B';

45: G_CANCEL_STATUS CONSTANT VARCHAR2(30) := 'CANCELED';
46: G_SUBMIT_STATUS CONSTANT VARCHAR2(30) := 'SUBMITTED';
47: G_PROCESSED_STATUS CONSTANT VARCHAR2(30) := 'PROCESSED';
48: G_AR_INV_LINE_CODE CONSTANT VARCHAR2(30) := 'LINE';
49: G_AR_LINES_SOURCE CONSTANT VARCHAR2(30) := 'OKL_TXL_AR_INV_LNS_B';
50: G_AR_CM_TRX_TYPE CONSTANT VARCHAR2(30) := 'CREDIT MEMO';
51: --global constants for billing trx creation
52: --Bug# 4899328
53: G_FORMULA_CAP CONSTANT VARCHAR2(200) := 'LINE_CAP_AMNT';

Line 6335: , OKL_TXL_AR_INV_LNS_B TIL

6331: p_chr_id IN NUMBER) IS
6332: SELECT TRX.ID
6333: , TRX.DESCRIPTION
6334: FROM OKL_TRX_AR_INVOICES_V TRX
6335: , OKL_TXL_AR_INV_LNS_B TIL
6336: WHERE TIL.TAI_ID = TRX.ID
6337: AND TIL.KLE_ID = p_cle_id -- subsidy cle id
6338: AND TRX.KHR_ID = p_chr_id
6339: AND TRX.TRX_STATUS_CODE = G_SUBMIT_STATUS;

Line 6471: , OKL_TXL_AR_INV_LNS_B TXL

6467: CURSOR c_chk_billing_done ( p_cle_id IN NUMBER
6468: , p_chr_id IN NUMBER) IS
6469: SELECT 'Y'
6470: FROM OKL_TRX_AR_INVOICES_B TAI
6471: , OKL_TXL_AR_INV_LNS_B TXL
6472: WHERE TXL.TAI_ID = TAI.ID
6473: AND TXL.KLE_ID = p_cle_id -- subsidy cle id
6474: AND TAI.KHR_ID = p_chr_id
6475: AND TAI.TRX_STATUS_CODE = G_PROCESSED_STATUS;