DBA Data[Home] [Help]

APPS.JL_JLBRRIVB_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 11: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;

7: GET_BASE_CURR_DATA;
8: RETURN (TRUE);
9: END BEFOREREPORT;
10: PROCEDURE GET_BASE_CURR_DATA IS
11: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;
12: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
13: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
14: BEGIN
15: BASE_CURR := '';

Line 12: PREC FND_CURRENCIES_VL.PRECISION%TYPE;

8: RETURN (TRUE);
9: END BEFOREREPORT;
10: PROCEDURE GET_BASE_CURR_DATA IS
11: BASE_CURR FND_CURRENCIES_VL.CURRENCY_CODE%TYPE;
12: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
13: ORG_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
14: BEGIN
15: BASE_CURR := '';
16: PREC := 0;

Line 26: FND_CURRENCIES_VL FCURR,

22: GSBKS.NAME
23: INTO BASE_CURR,PREC,ORG_NAME
24: FROM
25: AR_SYSTEM_PARAMETERS ASP,
26: FND_CURRENCIES_VL FCURR,
27: GL_SETS_OF_BOOKS GSBKS
28: WHERE ASP.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
29: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;
30: EXCEPTION