[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
FRV.RESPONSIBILITY_NAME,
TO_CHAR(FCR.REQUEST_DATE
,'YYYY/MM/DD HH24:MI:SS'),
FAV.APPLICATION_NAME,
FU.USER_NAME
INTO CP_RESPONSIBILITY,CP_REQUEST_TIME,CP_APPLICATION,CP_REQUESTED_BY
FROM
FND_CONCURRENT_REQUESTS FCR,
FND_RESPONSIBILITY_VL FRV,
FND_APPLICATION_VL FAV,
FND_USER FU
WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
AND FCR.RESPONSIBILITY_APPLICATION_ID = FRV.APPLICATION_ID
AND FCR.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
AND FRV.APPLICATION_ID = FAV.APPLICATION_ID
AND FU.USER_ID = FCR.REQUESTED_BY;
SELECT
DISTINCT
XFI.NAME,
CCG.COST_GROUP,
CCT.COST_TYPE,
GLL.CURRENCY_CODE,
CAH.PERIOD_NAME,
NVL(FC.PRECISION
,2)
INTO CP_LEGAL_ENTITY,CP_COST_GROUP,CP_COST_TYPE,R_CURRENCY_CODE,CP_PERIOD_NAME,CP_PRECISION
FROM
CST_AE_HEADERS CAH,
XLE_FIRSTPARTY_INFORMATION_V XFI,
GL_LEDGER_LE_V GLL,
CST_COST_GROUPS CCG,
CST_COST_TYPES CCT,
FND_CURRENCIES FC
WHERE CAH.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.LEGAL_ENTITY_ID = XFI.LEGAL_ENTITY_ID
AND GLL.RELATIONSHIP_ENABLED_FLAG = 'Y'
AND GLL.LEDGER_CATEGORY_CODE = 'PRIMARY'
AND CAH.COST_GROUP_ID = P_COST_GROUP_ID
AND CAH.PERIOD_ID = P_PERIOD_ID
AND CCG.COST_GROUP_ID = CAH.COST_GROUP_ID
AND CCT.COST_TYPE_ID = P_COST_TYPE_ID
AND FC.CURRENCY_CODE = GLL.CURRENCY_CODE;