[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ABB.BANK_NAME,
ABB.BANK_BRANCH_NAME,
L.MEANING,
L2.MEANING
INTO
C_BANK_NAME
,C_BANK_BRANCH_NAME
,C_TRANSACTION_TYPE
,C_RECEIPT_TRANSLATION
FROM
CE_BANK_BRANCHES_V ABB,
CE_LOOKUPS L,
CE_LOOKUPS L2
WHERE ABB.BRANCH_PARTY_ID = P_BANK_BRANCH
AND L.LOOKUP_TYPE = 'TRAN_ORG_TYPE'
AND L.LOOKUP_CODE = P_TYPE
AND L2.LOOKUP_TYPE = 'TRX_TYPE'
AND L2.LOOKUP_CODE = 'CASH';
SELECT
ABA.BANK_ACCOUNT_NUM,
ABA.BANK_ACCOUNT_NAME,
ABA.CURRENCY_CODE
INTO
C_BANK_ACCOUNT_NUM
,C_BANK_ACCOUNT_NAME
,C_BANK_CURRENCY_CODE
FROM
CE_BANK_ACCTS_GT_V ABA
WHERE ABA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT;
SELECT
SUM(NVL(C.AMOUNT
,0)),
SUM(NVL(C.BASE_AMOUNT
,C.AMOUNT))
INTO
C_BATCH_AMOUNT
,C_BATCH_BANK_ACCOUNT_AMOUNT
FROM
AP_CHECKS C
WHERE C.CHECKRUN_NAME = BATCH_NUMBER;
SELECT
SUM(NVL(C.CLEARED_AMOUNT
,0))
INTO
C_BATCH_CLEARED_AMOUNT
FROM
AP_CHECKS C
WHERE C.CHECKRUN_NAME = BATCH_NUMBER
AND C.CLEARED_DATE is not NULL;
SELECT
SUM(NVL(ARH.AMOUNT
,0)),
SUM(NVL(ARH.AMOUNT
,0)),
SUM(NVL(ARH.ACCTD_AMOUNT
,0))
INTO
C_BATCH_AMOUNT
,C_BATCH_CLEARED_AMOUNT
,C_BATCH_BANK_ACCOUNT_AMOUNT
FROM
AR_CASH_RECEIPT_HISTORY ARH
WHERE ARH.BATCH_ID = BATCH_ID_1
AND ARH.STATUS = 'CLEARED'
AND ARH.CURRENT_RECORD_FLAG = 'Y';