[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME,
REGISTRATION_NUMBER
INTO C_COMPANY_NAME,C_NIT_ID
FROM
XLE_FIRSTPARTY_INFORMATION_V
WHERE LEGAL_ENTITY_ID = T_LEGAL_ENTITY_ID;
SELECT
GLP.PERIOD_NUM,
GLP.PERIOD_YEAR
INTO P_NUM,P_YEAR
FROM
GL_PERIODS GLP,
GL_SETS_OF_BOOKS GLS
WHERE GLP.PERIOD_NAME = P_START_PERIOD
AND GLP.PERIOD_SET_NAME = GLS.PERIOD_SET_NAME
AND GLS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
SELECT
GLP.PERIOD_NUM,
GLP.PERIOD_YEAR
INTO P_NUM1,P_YEAR1
FROM
GL_PERIODS GLP,
GL_SETS_OF_BOOKS GLS
WHERE GLP.PERIOD_NAME = P_END_PERIOD
AND GLP.PERIOD_SET_NAME = GLS.PERIOD_SET_NAME
AND GLS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
SELECT
BAL.PERIOD_NAME,
SUM(BAL.BEGIN_BALANCE_DR),
SUM(BAL.BEGIN_BALANCE_CR),
SUM(BAL.PERIOD_NET_DR),
SUM(BAL.PERIOD_NET_CR),
BAL.ACCOUNT_CODE
INTO PN,BBDR,BBCR,PNDR,PNCR,ACODE
FROM
JL_CO_GL_BALANCES BAL
WHERE BAL.NIT_ID = NIT_ID
AND BAL.ACCOUNT_CODE = ACCOUNT
AND BAL.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
AND ( BAL.PERIOD_YEAR * 100 + BAL.PERIOD_NUM ) = (
SELECT
MAX(B1.PERIOD_YEAR * 100 + B1.PERIOD_NUM)
FROM
JL_CO_GL_BALANCES B1,
GL_CODE_COMBINATIONS GLCC
WHERE BAL.SET_OF_BOOKS_ID = B1.SET_OF_BOOKS_ID
AND BAL.ACCOUNT_CODE = B1.ACCOUNT_CODE
AND B1.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
AND BAL.NIT_ID = B1.NIT_ID
AND ( B1.PERIOD_YEAR * 100 + B1.PERIOD_NUM ) < ( NVL(C_PYEAR2
,0) * 100 + NVL(C_PNUM2
,0) )
AND B1.PERIOD_YEAR BETWEEN DECODE(GLCC.ACCOUNT_TYPE
,'R'
,C_PYEAR2
,'E'
,C_PYEAR2
,C_PYEAR2 - 200)
AND C_PYEAR2 )
GROUP BY
BAL.PERIOD_NAME,
BAL.ACCOUNT_CODE;