DBA Data[Home] [Help]

APPS.JE_JEFILPIP_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 46: AP_SYSTEM_PARAMETERS ASP,

42: C.PRECISION,
43: C.CURRENCY_CODE
44: INTO C_COAI,C_SOB,C_PRECISION,C_FUNCT_CURR
45: FROM
46: AP_SYSTEM_PARAMETERS ASP,
47: GL_SETS_OF_BOOKS GSOB,
48: FND_CURRENCIES_VL C
49: WHERE ASP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
50: AND ASP.BASE_CURRENCY_CODE = C.CURRENCY_CODE;

Line 228: AP_SYSTEM_PARAMETERS SP

224: GSOB.NAME
225: INTO APU
226: FROM
227: GL_SETS_OF_BOOKS GSOB,
228: AP_SYSTEM_PARAMETERS SP
229: WHERE GSOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID;
230: RETURN (APU);
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN

Line 339: AP_SYSTEM_PARAMETERS;

335: NVL(WHEN_TO_ACCOUNT_PMT
336: ,'X')
337: INTO L_CLEARING
338: FROM
339: AP_SYSTEM_PARAMETERS;
340: IF L_CLEARING = 'CLEARING ONLY' THEN
341: SQL_PAYMENTS2 := SQL_PAYMENTS2 || 'and trunc(c.cleared_date)<=''' || TO_CHAR(P_CUT_DATE) || ''' ';
342: ELSE
343: IF P_CONFIRMED = 'N' THEN