DBA Data[Home] [Help]

APPS.AR_ARZACS_XMLP_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 134: AR_SYSTEM_PARAMETERS AR

130: SOB.CURRENCY_CODE
131: INTO COMPANY_NAME,FUNC_CURRENCY_CODE
132: FROM
133: GL_SETS_OF_BOOKS SOB,
134: AR_SYSTEM_PARAMETERS AR
135: WHERE SOB.SET_OF_BOOKS_ID = AR.SET_OF_BOOKS_ID;
136: EXCEPTION
137: WHEN OTHERS THEN
138: /*SRW.MESSAGE(5000

Line 380: AR_SYSTEM_PARAMETERS ASP

376: count(*)
377: INTO OPEN_PERIODS
378: FROM
379: GL_PERIOD_STATUSES GPS,
380: AR_SYSTEM_PARAMETERS ASP
381: WHERE GPS.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID
382: AND GPS.APPLICATION_ID = 222
383: AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'
384: AND P_GL_DATE BETWEEN GPS.START_DATE