[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CONCURRENT_PROGRAM_ID,
NVL(ENABLE_TRACE
,'N')
FROM
FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = P_REQUEST_ID;
SELECT
A.SID,
A.SERIAL#,
B.SPID
FROM
V$SESSION A,
V$PROCESS B
WHERE AUDSID = USERENV('SESSIONID')
AND A.PADDR = B.ADDR;
SELECT
NAME
FROM
V$DATABASE;
SELECT
SUM(RECOVERED_AMOUNT)
FROM
JAI_RGM_TRX_REFS
WHERE SOURCE = CP_SOURCE
AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND ORGANIZATION_ID IN (
SELECT
DISTINCT
ORGANIZATION_ID
FROM
JAI_RGM_ORG_REGNS_V
WHERE REGIME_CODE = LV_SERVICE_REGIME
AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE
AND ATTRIBUTE_VALUE = P_REGM_PRMY_REGN )
AND ( NVL(TRUNC(CREATION_DATE)
,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
,SYSDATE) )
AND ( NVL(P_TO_DATE
,SYSDATE) );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_OUT
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
,SYSDATE) )
AND ( NVL(P_TO_DATE
,SYSDATE) );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = CP_SOURCE
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND SOURCE_TRX_TYPE IN ( LV_ADJUST_LIABILITY , LV_LIABILITY )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
,SYSDATE) )
AND ( NVL(P_TO_DATE
,SYSDATE) );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = CP_SOURCE
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND SOURCE_TRX_TYPE = CP_TRX_TYPE
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,SYSDATE) ) BETWEEN ( NVL(P_FROM_DATE
,SYSDATE) )
AND ( NVL(P_TO_DATE
,SYSDATE) );
SELECT
SUM(RECOVERED_AMOUNT)
FROM
JAI_RGM_TRX_REFS
WHERE SOURCE = CP_SOURCE
AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND TRUNC(CREATION_DATE) < P_FROM_DATE
AND ORGANIZATION_ID in (
SELECT
DISTINCT
ORGANIZATION_ID
FROM
JAI_RGM_ORG_REGNS_V
WHERE REGIME_CODE = LV_SERVICE_REGIME
AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE
AND ATTRIBUTE_VALUE = P_REGM_PRMY_REGN );
SELECT
SUM(CREDIT_AMOUNT)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_IN
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
,TRUNC(SYSDATE)) );
SELECT
SUM(CREDIT_AMOUNT)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = CP_SOURCE
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND SOURCE_TRX_TYPE IN ( LV_ADJUST_RECOVERY , LV_RECOVERY )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
,TRUNC(SYSDATE)) );
SELECT
SUM(RECOVERED_AMOUNT)
FROM
JAI_RGM_TRX_REFS
WHERE SOURCE = CP_SOURCE
AND TAX_TYPE in ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND TRUNC(CREATION_DATE) < P_FROM_DATE
AND ORGANIZATION_ID IN (
SELECT
DISTINCT
ORGANIZATION_ID
FROM
JAI_RGM_ORG_REGNS_V
WHERE REGIME_CODE = LV_SERVICE_REGIME
AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE
AND ATTRIBUTE_VALUE = P_REGM_PRMY_REGN );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = LV_SERVICE_SRC_DISTRIBUTE_OUT
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
,TRUNC(SYSDATE)) );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = CP_SOURCE
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SH_SER_EDU_CESS , LV_TAX_TYPE_SERVICE_EDU_CESS )
AND SOURCE_TRX_TYPE IN ( LV_LIABILITY , LV_ADJUST_LIABILITY )
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
,TRUNC(SYSDATE)) );
SELECT
NVL(SUM(DEBIT_AMOUNT)
,0)
FROM
JAI_RGM_TRX_RECORDS
WHERE SOURCE = CP_SOURCE
AND REGIME_CODE = LV_SERVICE_REGIME
AND TAX_TYPE IN ( LV_TAX_TYPE_SERVICE , LV_TAX_TYPE_SERVICE_EDU_CESS , LV_TAX_TYPE_SH_SER_EDU_CESS )
AND SOURCE_TRX_TYPE = CP_SOURCE_TRX_TYPE
AND REGIME_PRIMARY_REGNO = P_REGM_PRMY_REGN
AND ( NVL(TRUNC(CREATION_DATE)
,TRUNC(SYSDATE)) ) < ( NVL(P_FROM_DATE
,TRUNC(SYSDATE)) );
SELECT
DESCRIPTION DISPLAYED_FIELD
FROM
JA_LOOKUPS
WHERE LOOKUP_TYPE = 'JAI_SERVICE_TYPE'
AND LOOKUP_CODE = SERVICE_TYPE_CODE;
SELECT
SUM(AMOUNT_REMAINING) AMOUNT_REMAINING
FROM
AP_PAYMENT_SCHEDULES_ALL
WHERE INVOICE_ID = CF_VALUEFORMULA.INVOICE_ID;
SELECT
DISTINCT
HAOU1.NAME FROM_ORG,
HAOU2.NAME TO_ORG
FROM
JAI_RGM_DIS_SRC_HDRS SRC_HDRS,
JAI_RGM_DIS_SRC_TAXES SRC_TAXS,
JAI_RGM_DIS_DES_HDRS DES_HDRS,
JAI_RGM_DIS_DES_TAXES DES_TAXS,
HR_ALL_ORGANIZATION_UNITS HAOU1,
HR_ALL_ORGANIZATION_UNITS HAOU2
WHERE SRC_HDRS.TRANSFER_ID = DES_HDRS.TRANSFER_ID
AND SRC_HDRS.TRANSFER_ID = SRC_TAXS.TRANSFER_ID
AND DES_HDRS.TRANSFER_DESTINATION_ID = DES_TAXS.TRANSFER_DESTINATION_ID
AND DES_TAXS.TRANSFER_SOURCE_ID = SRC_TAXS.TRANSFER_SOURCE_ID
AND SRC_HDRS.TRANSFER_ID = SRC_DOC_ID
AND SRC_HDRS.PARTY_ID = HAOU1.ORGANIZATION_ID
AND DES_HDRS.DESTINATION_PARTY_ID = HAOU2.ORGANIZATION_ID;
SELECT
DISTINCT
DESCRIPTION
FROM
MTL_SYSTEM_ITEMS
WHERE INVENTORY_ITEM_ID = ITEM_ID;