DBA Data[Home] [Help]

APPS.JA_JAINBBR_XMLP_PKG dependencies on GL_JE_HEADERS

Line 184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;

180: V_AMOUNT2 NUMBER;
181: V_AMOUNT3 NUMBER;
182: V_BALANCE NUMBER;
183: V_SET_OF_BOOKS_ID NUMBER;
184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

Line 185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;

181: V_AMOUNT3 NUMBER;
182: V_BALANCE NUMBER;
183: V_SET_OF_BOOKS_ID NUMBER;
184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

Line 186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;

182: V_BALANCE NUMBER;
183: V_SET_OF_BOOKS_ID NUMBER;
184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

Line 187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;

183: V_SET_OF_BOOKS_ID NUMBER;
184: LV_PAY_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
185: LV_RCV_SOURCE GL_JE_HEADERS.JE_SOURCE%TYPE;
186: LV_PAY_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
187: LV_RCV_SOURCE1 GL_JE_HEADERS.JE_SOURCE%TYPE;
188: LV_CLEAR_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
189: LV_REMIT_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
190: LV_CONFIRM_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;
191: LV_REV_STATUS AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE;

Line 225: GL_JE_HEADERS GLH,

221: ,SUM(ACCOUNTED_CR)
222: ,0)
223: INTO V_AMOUNT2
224: FROM
225: GL_JE_HEADERS GLH,
226: GL_JE_LINES GLL,
227: CE_BANK_ACCOUNTS CBA
228: WHERE GLH.JE_HEADER_ID = GLL.JE_HEADER_ID
229: AND GLH.LEDGER_ID = GLL.LEDGER_ID