APPS.JL_JLMXFGLR_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 20: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

16: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
17: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
18: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
19: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
20: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
21: BEGIN
22: BASE_CURR := '';
23: PREC := 0;
24: MIN_AU := 0;

Line 39: GL_SETS_OF_BOOKS GSBKS

35: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
36: FROM
37: FA_BOOK_CONTROLS_MRC_V BKCTRL,
38: FND_CURRENCIES_VL FCURR,
39: GL_SETS_OF_BOOKS GSBKS
40: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
41: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
42: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;
43: EXCEPTION

Line 62: GL_SETS_OF_BOOKS GSBKS

58: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
59: FROM
60: FA_BOOK_CONTROLS BKCTRL,
61: FND_CURRENCIES_VL FCURR,
62: GL_SETS_OF_BOOKS GSBKS
63: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
64: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
65: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;
66: EXCEPTION

Line 947: GL_SETS_OF_BOOKS

943: MRC_SOB_TYPE_CODE,
944: CURRENCY_CODE
945: INTO P_MRCSOBTYPE,LP_CURRENCY_CODE
946: FROM
947: GL_SETS_OF_BOOKS
948: WHERE SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;
949: EXCEPTION
950: WHEN OTHERS THEN
951: P_MRCSOBTYPE := 'P';