[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_id
from xla_subledgers
where application_id=p_application_id;
l_select_clause VARCHAR2(2000);
l_select_clause := 'SELECT
AEL_V.CODE_COMBINATION_ID CC_ID
,TO_CHAR(AEL_V.CODE_COMBINATION_ID) SEGMENT1_VALUE
,TO_CHAR(NULL) SEGMENT2_VALUE
,TO_CHAR(NULL) SEGMENT3_VALUE
,TO_CHAR(NULL) SEGMENT4_VALUE
,AEL_V.AE_LINE_REFERENCE AE_LINE_REF
,AEL_V.AE_LINE_REFERENCE_INTERNAL AE_LINE_REF_INT
,AEL_V.CURRENCY_CODE CURRENCY_CODE
,AEL_V.ENTERED_DR ENTERED_DR
,AEL_V.ENTERED_CR ENTERED_CR
,AEL_V.ACCOUNTED_DR ACCOUNTED_DR
,AEL_V.ACCOUNTED_CR ACCOUNTED_CR
,TO_NUMBER(NULL) REPORT_DR
,TO_NUMBER(NULL) REPORT_CR
,TO_CHAR(NULL) PERIOD_NAME
,TO_CHAR(NULL) STATUS
,GLCC.ACCOUNT_TYPE ACCOUNT_TYPE ';
l_select_clause := 'SELECT
AEL_V.CODE_COMBINATION_ID CC_ID
,TO_CHAR(AEL_V.CODE_COMBINATION_ID) SEGMENT1_VALUE
,TO_CHAR(NULL) SEGMENT2_VALUE
,TO_CHAR(NULL) SEGMENT3_VALUE
,TO_CHAR(NULL) SEGMENT4_VALUE
,AEL_V.AE_LINE_REFERENCE AE_LINE_REF
,AEL_V.AE_LINE_REFERENCE_INTERNAL AE_LINE_REF_INT
,AEL_V.CURRENCY_CODE CURRENCY_CODE
,AEL_V.ENTERED_DR ENTERED_DR
,AEL_V.ENTERED_CR ENTERED_CR
,AEL_V.ACCOUNTED_DR ACCOUNTED_DR
,AEL_V.ACCOUNTED_CR ACCOUNTED_CR
,TO_NUMBER(NULL) REPORT_DR
,TO_NUMBER(NULL) REPORT_CR
,AEL_V.PERIOD_NAME PERIOD_NAME
,AEL_V.STATUS STATUS
,GLCC.ACCOUNT_TYPE ACCOUNT_TYPE ';
l_select_clause := 'SELECT
AEL_V.CODE_COMBINATION_ID CC_ID
,GLCC.'||l_segment1_column||' SEGMENT1_VALUE
,GLCC.'||l_segment2_column||' SEGMENT2_VALUE
,GLCC.'||l_segment3_column||' SEGMENT3_VALUE
,GLCC.'||l_segment4_column||' SEGMENT4_VALUE
,AEL_V.AE_LINE_REFERENCE AE_LINE_REF
,AEL_V.AE_LINE_REFERENCE_INTERNAL AE_LINE_REF_INT
,AEL_V.CURRENCY_CODE CURRENCY_CODE
,AEL_V.ENTERED_DR ENTERED_DR
,AEL_V.ENTERED_CR ENTERED_CR
,AEL_V.ACCOUNTED_DR ACCOUNTED_DR
,AEL_V.ACCOUNTED_CR ACCOUNTED_CR
,TO_NUMBER(NULL) REPORT_DR
,TO_NUMBER(NULL) REPORT_CR
,TO_CHAR(NULL) PERIOD_NAME
,TO_CHAR(NULL) STATUS
,GLCC.ACCOUNT_TYPE ACCOUNT_TYPE ';
l_select_clause := 'SELECT
AEL_V.CODE_COMBINATION_ID CC_ID
,GLCC.'||l_segment1_column||' SEGMENT1_VALUE
,GLCC.'||l_segment2_column||' SEGMENT2_VALUE
,GLCC.'||l_segment3_column||' SEGMENT3_VALUE
,GLCC.'||l_segment4_column||' SEGMENT4_VALUE
,AEL_V.AE_LINE_REFERENCE AE_LINE_REF
,AEL_V.AE_LINE_REFERENCE_INTERNAL AE_LINE_REF_INT
,AEL_V.CURRENCY_CODE CURRENCY_CODE
,AEL_V.ENTERED_DR ENTERED_DR
,AEL_V.ENTERED_CR ENTERED_CR
,AEL_V.ACCOUNTED_DR ACCOUNTED_DR
,AEL_V.ACCOUNTED_CR ACCOUNTED_CR
,TO_NUMBER(NULL) REPORT_DR
,TO_NUMBER(NULL) REPORT_CR
,AEL_V.PERIOD_NAME PERIOD_NAME
,AEL_V.STATUS STATUS
,GLCC.ACCOUNT_TYPE ACCOUNT_TYPE ';
l_statement := l_select_clause ||' '||l_from_clause||' '||
l_where_clause ||' '||l_group_by_clause||' '||
l_order_by_clause;
SELECT CURRENCY_CODE
FROM GL_LEDGERS
WHERE ledger_id= pSetOfBooksID;
SELECT CHART_OF_ACCOUNTS_ID
FROM GL_LEDGERS
WHERE ledger_id= pSetOfBooksID;
SELECT ( nvl(BA.begin_balance_dr,0) -
nvl(BA.begin_balance_cr,0) ) +
( nvl(BA.period_net_dr,0) -
nvl(BA.period_net_cr,0) ) FUNCTIONAL_YEAR_TO_DATE
FROM GL_BALANCES BA
WHERE BA.CODE_COMBINATION_ID = p_CODE_COMBINATION_ID
AND BA.ledger_id = prv_SetOfBooksID -- updated by weshen
AND BA.PERIOD_NAME = p_PERIOD_NAME
AND BA.ACTUAL_FLAG = 'A'
AND BA.CURRENCY_CODE = g_AccountingCurrency;
SELECT SUM(Nvl(accounted_Dr,0))- SUM(Nvl(Accounted_Cr,0))
INTO l_amount
FROM gl_je_lines
WHERE je_header_id = p_trx_hdr_id
AND code_combination_id = p_Ccid;