[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SUBSTR(CP.USER_CONCURRENT_PROGRAM_NAME
,1
,80)
INTO L_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL CP,
FND_CONCURRENT_REQUESTS CR
WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
SELECT
count(*)
INTO L_BANK_COUNT
FROM
CE_BANK_ACCT_USES BA,
CE_BANK_ACCOUNTS CBA,
CE_BANK_BRANCHES_V BB
WHERE BA.BANK_ACCT_USE_ID in (
SELECT
DISTINCT
REMIT_BANK_ACCT_USE_ID
FROM
AR_CASH_RECEIPTS )
AND CBA.BANK_BRANCH_ID = BB.BRANCH_PARTY_ID
AND CBA.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
AND CBA.BANK_ACCOUNT_NAME between DECODE(P_BANK_ACCOUNT_NAME_LOW
,NULL
,CBA.BANK_ACCOUNT_NAME
,P_BANK_ACCOUNT_NAME_LOW)
AND DECODE(P_BANK_ACCOUNT_NAME_HIGH
,NULL
,CBA.BANK_ACCOUNT_NAME
,P_BANK_ACCOUNT_NAME_HIGH);
SELECT
DECODE(CR_STATUS
,'REV'
,0
,AMOUNT),
DECODE(CR_STATUS
,'UNID'
,AMOUNT
,0),
DECODE(CR_TYPE
,'MISC'
,DECODE(CR_STATUS
,'APP'
,AMOUNT
,0)
,0),
DECODE(CR_STATUS
,REVERSAL_CATEGORY
,DECODE(CR_STATUS
,'NSF'
,AMOUNT
,'STOP'
,AMOUNT
,0)
,0),
DECODE(CR_STATUS
,'APP'
,1
,''),
DECODE(CR_STATUS
,'UNAPP'
,1
,0),
DECODE(CR_STATUS
,'UNID'
,1
,0),
DECODE(CR_TYPE
,'MISC'
,1
,0)
INTO L_ACTUAL_AMOUNT,L_UNIDENTIFIED_AMOUNT,L_MISC_AMOUNT,L_NSF_AMOUNT,L_APPLIED_COUNT,L_UNAPPLIED_COUNT,L_UNIDENTIFIED_COUNT,L_MISC_COUNT
FROM
DUAL;
SELECT
SUM(AMOUNT_APPLIED)
INTO L_ON_ACCOUNT_AMOUNT
FROM
AR_RECEIVABLE_APPLICATIONS
WHERE CASH_RECEIPT_ID = F_AMOUNTSFORMULA.CASH_RECEIPT_ID
AND STATUS = 'ACC';
SELECT
DECODE(CR_STATUS_BB
,'REV'
,0
,AMOUNT_B),
DECODE(CR_STATUS_BB
,'UNID'
,AMOUNT_B
,0),
DECODE(CR_TYPE_B
,'MISC'
,DECODE(CR_STATUS_BB
,'APP'
,AMOUNT_B
,0)
,0),
DECODE(CR_STATUS_BB
,REVERSAL_CATEGORY_B
,DECODE(CR_STATUS_BB
,'NSF'
,AMOUNT_B
,'STOP'
,AMOUNT_B
,0)
,0),
DECODE(CR_STATUS_BB
,'APP'
,1
,''),
DECODE(CR_STATUS_BB
,'UNAPP'
,1
,0),
DECODE(CR_STATUS_BB
,'UNID'
,1
,0),
DECODE(CR_TYPE_B
,'MISC'
,1
,0)
INTO L_ACTUAL_AMOUNT,L_UNIDENTIFIED_AMOUNT,L_MISC_AMOUNT,L_NSF_AMOUNT,L_APPLIED_COUNT,L_UNAPPLIED_COUNT,L_UNIDENTIFIED_COUNT,L_MISC_COUNT
FROM
DUAL;
SELECT
SUM(AMOUNT_APPLIED)
INTO L_ON_ACCOUNT_AMOUNT
FROM
AR_RECEIVABLE_APPLICATIONS
WHERE CASH_RECEIPT_ID = CASH_RECEIPT_ID_B
AND STATUS = 'ACC';
SELECT
MEANING
INTO L_ORDER_BY
FROM
AR_LOOKUPS
WHERE LOOKUP_TYPE = 'SORT_BY_ARXSOC'
AND LOOKUP_CODE = PH_ORDER_BY;