DBA Data[Home] [Help]

APPS.JE_JEFIASDR_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 24: FA_BOOK_CONTROLS BC

20: FROM
21: FND_CURRENCIES_VL CR,
22: FA_SYSTEM_CONTROLS SC,
23: GL_LEDGERS_PUBLIC_V SOB,
24: FA_BOOK_CONTROLS BC
25: WHERE BC.BOOK_TYPE_CODE = P_TAX_BOOK
26: AND SOB.LEDGER_ID = BC.SET_OF_BOOKS_ID
27: AND CR.CURRENCY_CODE = SOB.CURRENCY_CODE;
28: /*SRW.MESSAGE(002

Line 74: FA_BOOK_CONTROLS C

70: INTO C_FROM_OPEN_DATE,C_FROM_CLOSE_DATE,C_REPORT_DATE,C_FROM_COUNTER,C_CALENDAR_OPEN_DATE,C_CALENDAR_CLOSE_DATE,C_FROM_FISCAL_YEAR,C_TO_COUNTER,C_TO_OPEN_DATE,C_TO_CLOSE_DATE,C_TIME_TO_CLOSE_DATE
71: FROM
72: FA_DEPRN_PERIODS F,
73: FA_DEPRN_PERIODS T,
74: FA_BOOK_CONTROLS C
75: WHERE F.PERIOD_COUNTER = (
76: SELECT
77: MIN(F1.PERIOD_COUNTER)
78: FROM

Line 206: FA_BOOK_CONTROLS C

202: T.PERIOD_CLOSE_DATE CORP_TIME_TO_CLOSE_DATE
203: INTO C_CORP_TO_OPEN_DATE,C_CORP_TO_CLOSE_DATE,C_CORP_TIME_TO_CLOSE_DATE
204: FROM
205: FA_DEPRN_PERIODS T,
206: FA_BOOK_CONTROLS C
207: WHERE T.PERIOD_COUNTER = C_CORP_TO_COUNTER
208: AND T.BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
209: AND T.FISCAL_YEAR = C_FROM_FISCAL_YEAR
210: AND C.BOOK_TYPE_CODE = T.BOOK_TYPE_CODE;

Line 232: FA_BOOK_CONTROLS

228: SELECT
229: LAST_DEPRN_RUN_DATE
230: INTO C_TIME_TO_CLOSE_DATE
231: FROM
232: FA_BOOK_CONTROLS
233: WHERE BOOK_TYPE_CODE = P_TAX_BOOK;
234: IF P_DEBUG_SWITCH = 'Y' THEN
235: /*SRW.MESSAGE(007
236: ,'C_time_to_close_date is ' || C_TIME_TO_CLOSE_DATE)*/NULL;

Line 244: FA_BOOK_CONTROLS

240: SELECT
241: LAST_DEPRN_RUN_DATE
242: INTO C_CORP_TIME_TO_CLOSE_DATE
243: FROM
244: FA_BOOK_CONTROLS
245: WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK;
246: IF P_DEBUG_SWITCH = 'Y' THEN
247: /*SRW.MESSAGE(008
248: ,'C_corp_time_to_close_date is ' || C_CORP_TIME_TO_CLOSE_DATE)*/NULL;