APPS.JA_JAINAPCR_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 107: GL_SETS_OF_BOOKS

103: SELECT
104: CURRENCY_CODE
105: INTO V_FUNCTIONAL_CURRENCY
106: FROM
107: GL_SETS_OF_BOOKS
108: WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;
109: IF (NVL(INVOICE_TYPE_LOOKUP_CODE
110: ,'N') = ('GAIN/LOSS')) THEN
111: /*SRW.MESSAGE('9'

Line 163: GL_SETS_OF_BOOKS

159: SELECT
160: CURRENCY_CODE
161: INTO V_FUNCTIONAL_CURRENCY
162: FROM
163: GL_SETS_OF_BOOKS
164: WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;
165: IF (NVL(INVOICE_TYPE_LOOKUP_CODE
166: ,'N') = ('GAIN/LOSS')) THEN
167: IF (ACCT_CR = 0) THEN

Line 223: GL_SETS_OF_BOOKS_V

219: SELECT
220: NAME
221: INTO V_NAME
222: FROM
223: GL_SETS_OF_BOOKS_V
224: WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;
225: RETURN (V_NAME);
226: RETURN NULL;
227: EXCEPTION

Line 265: GL_SETS_OF_BOOKS

261: SELECT
262: CURRENCY_CODE
263: INTO V_FUNCTIONAL_CURRENCY
264: FROM
265: GL_SETS_OF_BOOKS
266: WHERE SET_OF_BOOKS_ID = V_SET_OF_BOOKS_ID;
267: V_DEBIT_BALANCE := JAI_AP_RPT_APCR_PKG.COMPUTE_DEBIT_BALANCE(CAL_DATE
268: ,V_VENDOR_ID
269: ,V_SET_OF_BOOKS_ID

Line 348: GL_SETS_OF_BOOKS

344: CURSOR FOR_SOB_NAME(SOB_ID IN NUMBER) IS
345: SELECT
346: NAME
347: FROM
348: GL_SETS_OF_BOOKS
349: WHERE SET_OF_BOOKS_ID = SOB_ID;
350: V_SET_OF_BOOKS_ID NUMBER;
351: V_SOB_NAME VARCHAR2(100);
352: BEGIN