APPS.JL_JLBRRCAD_XMLP_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 83: AR_SYSTEM_PARAMETERS ASP,

79: FCURR.DESCRIPTION,
80: GSBKS.NAME
81: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
82: FROM
83: AR_SYSTEM_PARAMETERS ASP,
84: FND_CURRENCIES_VL FCURR,
85: GL_SETS_OF_BOOKS GSBKS
86: WHERE ASP.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
87: AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line 127: L_LEDGER_ID AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE;

123: PROCEDURE GET_COMPANY_NAME IS
124: L_NAME VARCHAR2(80);
125: L_RETURN_STATUS VARCHAR2(2000);
126: L_MSG_DATA VARCHAR2(2000);
127: L_LEDGER_ID AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE;
128: L_ACCT_BALANCING_SEGMENT AR_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE1%TYPE;
129: L_LEDGER_INFO XLE_BUSINESSINFO_GRP.LE_LEDGER_REC_TYPE;
130: L_LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
131: L_LEGAL_ENTITY_NAME XLE_ENTITY_PROFILES.NAME%TYPE;

Line 128: L_ACCT_BALANCING_SEGMENT AR_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE1%TYPE;

124: L_NAME VARCHAR2(80);
125: L_RETURN_STATUS VARCHAR2(2000);
126: L_MSG_DATA VARCHAR2(2000);
127: L_LEDGER_ID AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE;
128: L_ACCT_BALANCING_SEGMENT AR_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE1%TYPE;
129: L_LEDGER_INFO XLE_BUSINESSINFO_GRP.LE_LEDGER_REC_TYPE;
130: L_LEGAL_ENTITY_ID XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
131: L_LEGAL_ENTITY_NAME XLE_ENTITY_PROFILES.NAME%TYPE;
132: BEGIN

Line 138: AR_SYSTEM_PARAMETERS;

134: SET_OF_BOOKS_ID,
135: GLOBAL_ATTRIBUTE1
136: INTO L_LEDGER_ID,L_ACCT_BALANCING_SEGMENT
137: FROM
138: AR_SYSTEM_PARAMETERS;
139: SELECT
140: ETB.ESTABLISHMENT_NAME
141: INTO L_LEGAL_ENTITY_NAME
142: FROM