DBA Data[Home] [Help]

APPS.JL_JLARFEFR_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 137: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;

133: RETURN (TRUE);
134: END BEFOREREPORT;
135:
136: PROCEDURE GET_BASE_CURR_DATA IS
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;

Line 138: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

134: END BEFOREREPORT;
135:
136: PROCEDURE GET_BASE_CURR_DATA IS
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

Line 139: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

135:
136: PROCEDURE GET_BASE_CURR_DATA IS
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 := '';

Line 140: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;

136: PROCEDURE GET_BASE_CURR_DATA IS
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;

Line 159: FND_CURRENCIES_VL FCURR,

155: GSBKS.NAME
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;

Line 182: FND_CURRENCIES_VL FCURR,

178: GSBKS.NAME
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;