[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SOB.LEDGER_ID,
SOB.NAME,
SC.CATEGORY_FLEX_STRUCTURE,
BC.BOOK_TYPE_CODE,
BC.ACCOUNTING_FLEX_STRUCTURE,
BC.DISTRIBUTION_SOURCE_BOOK,
SOB.CURRENCY_CODE,
CR.PRECISION
INTO C_SET_OF_BOOKS_ID,C_SOB_NAME,C_CAT_FLEX_STRUCT,C_BOOK_TYPE_CODE,C_ACCT_FLEX_STRUCT,C_DISTRIBUTION_SOURCE_BOOK,C_CURRENCY_CODE,C_PRECISION
FROM
FND_CURRENCIES_VL CR,
FA_SYSTEM_CONTROLS SC,
GL_LEDGERS_PUBLIC_V SOB,
FA_BOOK_CONTROLS BC
WHERE BC.BOOK_TYPE_CODE = P_TAX_BOOK
AND SOB.LEDGER_ID = BC.SET_OF_BOOKS_ID
AND CR.CURRENCY_CODE = SOB.CURRENCY_CODE;
SELECT
F.PERIOD_OPEN_DATE FROM_OPEN_DATE,
NVL(F.PERIOD_CLOSE_DATE
,SYSDATE) FROM_CLOSE_DATE,
sysdate REPORT_DATE,
F.PERIOD_COUNTER FROM_COUNTER,
F.CALENDAR_PERIOD_OPEN_DATE CALENDAR_OPEN_DATE,
NVL(T.CALENDAR_PERIOD_CLOSE_DATE
,SYSDATE) CALENDAR_CLOSE_DATE,
F.FISCAL_YEAR FROM_FISCAL_YEAR,
T.PERIOD_COUNTER TO_COUNTER,
T.PERIOD_OPEN_DATE TO_OPEN_DATE,
NVL(T.PERIOD_CLOSE_DATE
,C.LAST_DEPRN_RUN_DATE),
T.PERIOD_CLOSE_DATE TIME_TO_CLOSE_DATE
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
FROM
FA_DEPRN_PERIODS F,
FA_DEPRN_PERIODS T,
FA_BOOK_CONTROLS C
WHERE F.PERIOD_COUNTER = (
SELECT
MIN(F1.PERIOD_COUNTER)
FROM
FA_DEPRN_PERIODS F1
WHERE F1.BOOK_TYPE_CODE = P_TAX_BOOK
AND F1.FISCAL_YEAR = F.FISCAL_YEAR )
AND T.PERIOD_NAME = P_PERIOD_NAME
AND F.BOOK_TYPE_CODE = P_TAX_BOOK
AND T.BOOK_TYPE_CODE = P_TAX_BOOK
AND T.FISCAL_YEAR = F.FISCAL_YEAR
AND C.BOOK_TYPE_CODE = T.BOOK_TYPE_CODE
AND C.BOOK_TYPE_CODE = F.BOOK_TYPE_CODE;
SELECT
MIN(L.PERIOD_COUNTER)
INTO CP_LASTYR_BEGIN_PERIOD_COUNTER
FROM
FA_DEPRN_PERIODS P,
FA_DEPRN_PERIODS L
WHERE P.BOOK_TYPE_CODE = P_TAX_BOOK
AND L.BOOK_TYPE_CODE = P_TAX_BOOK
AND P.PERIOD_NAME = P_PERIOD_NAME
AND L.FISCAL_YEAR = P.FISCAL_YEAR - 1;
SELECT
MIN(PERIOD_COUNTER) CORPORATE_FROM_COUNTER,
MIN(CALENDAR_PERIOD_OPEN_DATE) CORPORATE_CALENDAR_OPEN_DATE
INTO C_CORP_FROM_COUNTER,C_CORP_CALENDAR_OPEN_DATE
FROM
FA_DEPRN_PERIODS
WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
AND FISCAL_YEAR = C_FROM_FISCAL_YEAR;
SELECT
MAX(PERIOD_COUNTER) CORPORATE_TO_COUNTER,
NVL(MAX(CALENDAR_PERIOD_CLOSE_DATE)
,SYSDATE) CORPORATE_CALENDAR_CLOSE_DATE
INTO C_CORP_TO_COUNTER,C_CORP_CALENDAR_CLOSE_DATE
FROM
FA_DEPRN_PERIODS
WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
AND C_CALENDAR_CLOSE_DATE between CALENDAR_PERIOD_OPEN_DATE
AND CALENDAR_PERIOD_CLOSE_DATE
AND FISCAL_YEAR = C_FROM_FISCAL_YEAR;
SELECT
T.PERIOD_OPEN_DATE CORP_TO_OPEN_DATE,
NVL(T.PERIOD_CLOSE_DATE
,C.LAST_DEPRN_RUN_DATE),
T.PERIOD_CLOSE_DATE CORP_TIME_TO_CLOSE_DATE
INTO C_CORP_TO_OPEN_DATE,C_CORP_TO_CLOSE_DATE,C_CORP_TIME_TO_CLOSE_DATE
FROM
FA_DEPRN_PERIODS T,
FA_BOOK_CONTROLS C
WHERE T.PERIOD_COUNTER = C_CORP_TO_COUNTER
AND T.BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK
AND T.FISCAL_YEAR = C_FROM_FISCAL_YEAR
AND C.BOOK_TYPE_CODE = T.BOOK_TYPE_CODE;
SELECT
LAST_DEPRN_RUN_DATE
INTO C_TIME_TO_CLOSE_DATE
FROM
FA_BOOK_CONTROLS
WHERE BOOK_TYPE_CODE = P_TAX_BOOK;
SELECT
LAST_DEPRN_RUN_DATE
INTO C_CORP_TIME_TO_CLOSE_DATE
FROM
FA_BOOK_CONTROLS
WHERE BOOK_TYPE_CODE = C_DISTRIBUTION_SOURCE_BOOK;
SELECT
PERIOD_CLOSE_DATE
INTO CP_CLOSE_DATE
FROM
FA_DEPRN_PERIODS
WHERE BOOK_TYPE_CODE = P_TAX_BOOK
AND PERIOD_COUNTER = C_TO_COUNTER;
SELECT
FFS.FLEX_VALUE_SET_ID
INTO C_ACCOUNT_FLEX_ID
FROM
FND_APPLICATION_VL FAP,
FND_ID_FLEX_SEGMENTS_VL FFS,
FND_ID_FLEX_STRUCTURES FIF,
FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FAP.APPLICATION_SHORT_NAME = 'SQLGL'
AND FFS.APPLICATION_ID = FAP.APPLICATION_ID
AND FFS.ID_FLEX_CODE = 'GL#'
AND FFS.ID_FLEX_NUM = C_ACCT_FLEX_STRUCT
AND FIF.APPLICATION_ID = FAP.APPLICATION_ID
AND FIF.ID_FLEX_CODE = FFS.ID_FLEX_CODE
AND FIF.ID_FLEX_NUM = FFS.ID_FLEX_NUM
AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
AND FSAV.APPLICATION_ID = FAP.APPLICATION_ID
AND FSAV.ID_FLEX_NUM = FFS.ID_FLEX_NUM
AND FSAV.ID_FLEX_CODE = FFS.ID_FLEX_CODE
AND FSAV.APPLICATION_COLUMN_NAME = FFS.APPLICATION_COLUMN_NAME
AND FSAV.ATTRIBUTE_VALUE = 'Y';
,'ERROR. GL Account Flex value selection brings back too many rows')*/NULL;
,'ERROR. GL Acccount Flex value selection brings back no rows')*/NULL;
SELECT
USER_CONCURRENT_PROGRAM_NAME
INTO CP_REPORT_NAME
FROM
FND_CONCURRENT_REQUESTS R,
FND_CONCURRENT_PROGRAMS_VL P
WHERE R.REQUEST_ID = P_CONC_REQUEST_ID
AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID;
SELECT
FVS.DESCRIPTION
INTO P_DESCR
FROM
FND_FLEX_VALUES_VL FVS
WHERE FVS.FLEX_VALUE_SET_ID = C_ACCOUNT_FLEX_ID
AND FVS.FLEX_VALUE = P_ACCOUNT;
,'ERROR. Selecting account segment description')*/NULL;
FUNCTION SELECT_ALL_P RETURN VARCHAR2 IS
BEGIN
RETURN SELECT_ALL;
END SELECT_ALL_P;