[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT '
||' nvl(ACC_STR_V.concatenated_segments, '''') acc_str '
||' FROM Ja_Cn_Sub_Acc_Sources_All SOURCE '
||' ,' || l_account_structures_kfv || ' ACC_STR_V '
||'WHERE ACC_STR_V.account_structure_id = SOURCE.ACCOUNTING_STRUCT_ID'
||' AND SOURCE.CHART_OF_ACCOUNTS_ID = ' || l_coa_id --using variable l_coa_id
;
SELECT jcsp.BOOK_NAME
,jcsp.COMPANY_NAME
,jcsp.book_num
,jcsp.ORGANIZATION_ID
,jcsp.ENT_QUALITY
,jcsp.ENT_INDUSTRY
INTO g_book_name
,g_company_name
,g_book_num
,g_organization_id
,g_ent_quality
,g_ent_industry
FROM JA_CN_SYSTEM_PARAMETERS_ALL jcsp
WHERE jcsp.legal_entity_id = l_le_id ;
select sasc.accounting_struct_id
into l_account_structure_id
from JA_CN_SUB_ACC_SOURCES_ALL sasc
where sasc.chart_of_accounts_id=l_coa_id;
SELECT fct.NAME
INTO g_functional_currency
FROM Gl_LEDGERS ledger, FND_CURRENCIES_TL fct
WHERE ledger.currency_code = fct.currency_code
AND fct.LANGUAGE = userenv('lang')
AND ledger.ledger_id = P_LEDGER_ID;
SELECT major_version || '.' || minor_version || '.' || tape_version
INTO g_software_version
FROM ad_releases
WHERE tape_version IN
(SELECT MAX(tape_version)
FROM ad_releases
WHERE minor_version IN
(SELECT MAX(minor_version)
FROM ad_releases
WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
)
AND major_version IN (SELECT MAX(major_version) FROM ad_releases)
)
AND minor_version IN
(SELECT MAX(minor_version)
FROM ad_releases
WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
)
AND major_version IN (SELECT MAX(major_version) FROM ad_releases);