APPS.JL_JLARFEFR_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 141: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

137: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;
138: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
139: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
140: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
141: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
142: BEGIN
143: BASE_CURR := '';
144: PREC := 0;
145: MIN_AU := 0;

Line 160: GL_SETS_OF_BOOKS GSBKS

156: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
157: FROM
158: FA_BOOK_CONTROLS_MRC_V BKCTRL,
159: FND_CURRENCIES_VL FCURR,
160: GL_SETS_OF_BOOKS GSBKS
161: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
162: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
163: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;
164: EXCEPTION

Line 183: GL_SETS_OF_BOOKS GSBKS

179: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
180: FROM
181: FA_BOOK_CONTROLS BKCTRL,
182: FND_CURRENCIES_VL FCURR,
183: GL_SETS_OF_BOOKS GSBKS
184: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
185: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
186: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;
187: EXCEPTION

Line 248: GL_SETS_OF_BOOKS

244: MRC_SOB_TYPE_CODE,
245: CURRENCY_CODE
246: INTO P_MRCSOBTYPE,LP_CURRENCY_CODE
247: FROM
248: GL_SETS_OF_BOOKS
249: WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;
250: EXCEPTION
251: WHEN OTHERS THEN
252: P_MRCSOBTYPE := 'P';