[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
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_PYEAR
,0) * 100 + NVL(C_PNUM
,0) )
AND B1.PERIOD_YEAR BETWEEN DECODE(GLCC.ACCOUNT_TYPE
,'R'
,C_PYEAR
,'E'
,C_PYEAR
,C_PYEAR - 200)
AND C_PYEAR )
GROUP BY
BAL.PERIOD_NAME,
BAL.ACCOUNT_CODE;
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;