[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CB.SET_OF_BOOKS_ID,
CB.CASHBOOK_BEGIN_DATE
INTO
C_SET_OF_BOOKS_ID
,C_CASHBOOK_BEGIN_DATE
FROM
CE_SYSTEM_PARAMETERS CB,
CE_BANK_ACCTS_GT_V BA
WHERE CB.LEGAL_ENTITY_ID = BA.ACCOUNT_OWNER_ORG_ID
AND BA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;
SELECT
GL.SET_OF_BOOKS_ID,
GL.CURRENCY_CODE,
GL.CHART_OF_ACCOUNTS_ID,
L.MEANING,
P.END_DATE
INTO
C_SET_OF_BOOKS_ID
,C_GL_CURRENCY_CODE
,C_CHART_OF_ACCOUNTS_ID
,C_ALL_TRANSLATION
,C_AS_OF_DATE
FROM
GL_SETS_OF_BOOKS GL,
CE_LOOKUPS L,
GL_PERIOD_STATUSES P
WHERE P.PERIOD_NAME = P_PERIOD_NAME
AND P.APPLICATION_ID = 101
AND P.SET_OF_BOOKS_ID = C_SET_OF_BOOKS_ID
AND GL.SET_OF_BOOKS_ID = C_SET_OF_BOOKS_ID
AND L.LOOKUP_TYPE = 'LITERAL'
AND L.LOOKUP_CODE = 'ALL';
SELECT
( G.SHORT_NAME || ': ' || SUBSTR(G.CURRENCY_CODE
,1
,5) )
INTO
C_NAME
FROM
GL_SETS_OF_BOOKS G
WHERE G.SET_OF_BOOKS_ID = C_SET_OF_BOOKS_ID;
SELECT
ABB.BANK_BRANCH_NAME,
ABB.BANK_NAME,
ABA.BANK_ACCOUNT_NAME,
ABA.BANK_ACCOUNT_NUM,
ABA.CURRENCY_CODE,
ABA.ASSET_CODE_COMBINATION_ID,
ABA.CASH_CLEARING_CCID
INTO
C_BANK_BRANCH_DSP
,C_BANK_NAME_DSP
,C_ACCOUNT_NAME_DSP
,C_ACCOUNT_NUMBER_DSP
,C_BANK_CURR_DSP
,C_ASSET_CC_ID
,P_CLEARING_CCID
FROM
CE_BANK_BRANCHES_V ABB,
CE_BANK_ACCTS_GT_V ABA
WHERE ABB.BRANCH_PARTY_ID = ABA.BANK_BRANCH_ID
AND ABA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;
SELECT
DISTINCT
GAC.ASSET_CODE_COMBINATION_ID
INTO
C_ASSET_CC_ID
FROM
CE_BANK_ACCT_USES_OU_V BAU,
CE_GL_ACCOUNTS_CCID GAC
WHERE GAC.BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID
AND BAU.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;