APPS.JL_JLCOPWHR_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 17: AP_SYSTEM_PARAMETERS A

13: ( CHART_OF_ACCOUNTS_ID )
14: INTO L_CHART_OF_ACCOUNTS_ID
15: FROM
16: GL_SETS_OF_BOOKS G,
17: AP_SYSTEM_PARAMETERS A
18: WHERE G.SET_OF_BOOKS_ID = P_SOB_ID;
19: P_COA_ID := L_CHART_OF_ACCOUNTS_ID;
20: /*SRW.REFERENCE(P_COA_ID)*/NULL;
21: /*SRW.REFERENCE(P_COA_ID)*/NULL;

Line 27: AP_SYSTEM_PARAMETERS P,

23: P.BASE_CURRENCY_CODE,
24: C.PRECISION
25: INTO BASE_CURR,PREC
26: FROM
27: AP_SYSTEM_PARAMETERS P,
28: FND_CURRENCIES_VL C
29: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE
30: AND P.SET_OF_BOOKS_ID = P_SOB_ID;
31:

Line 125: AP_SYSTEM_PARAMETERS_ALL A

121: CHART_OF_ACCOUNTS_ID
122: INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
123: FROM
124: GL_SETS_OF_BOOKS G,
125: AP_SYSTEM_PARAMETERS_ALL A
126: WHERE G.SET_OF_BOOKS_ID = A.SET_OF_BOOKS_ID;
127: C_COMPANY_NAME_HEADER := L_NAME;
128: C_CHART_OF_ACCOUNTS_ID := L_CHART_OF_ACCOUNTS_ID;
129: C_REPORT_START_DATE := L_REPORT_START_DATE;

Line 153: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

149: RETURN (CF_1);
150: END CP_1FORMULA;
151:
152: FUNCTION GET_BASE_CURR_DATA RETURN BOOLEAN IS
153: BASE_CURR AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
154: PREC FND_CURRENCIES_VL.PRECISION%TYPE;
155: MIN_AU FND_CURRENCIES_VL.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
156: DESCR FND_CURRENCIES_VL.DESCRIPTION%TYPE;
157: BEGIN

Line 169: AP_SYSTEM_PARAMETERS P,

165: C.MINIMUM_ACCOUNTABLE_UNIT,
166: C.DESCRIPTION
167: INTO BASE_CURR,PREC,MIN_AU,DESCR
168: FROM
169: AP_SYSTEM_PARAMETERS P,
170: FND_CURRENCIES_VL C
171: WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
172: C_BASE_CURRENCY_CODE := BASE_CURR;
173: C_BASE_PRECISION := PREC;