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 6298: , OKL_TXL_AR_INV_LNS_B TIL

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
6302: AND TRX.TRX_STATUS_CODE = G_SUBMIT_STATUS;

Line 6385: , OKL_TXL_AR_INV_LNS_B TXL

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
6389: AND TAI.TRX_STATUS_CODE = G_PROCESSED_STATUS;