The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select Legal_entity_name
INTO l_legal_entity_name
FROM GL_LEDGER_LE_V
WHERE legal_entity_id = p_legal_entity_id
AND ledger_id = p_sob_id;
SELECT NVL(legal_entity_id,-1)
INTO l_legal_entity_id
FROM RA_CUST_TRX_TYPES
WHERE cust_trx_type_id = p_trx_type_id;
SELECT NVL(legal_entity_id,-1)
INTO l_legal_entity_id
FROM RA_BATCH_SOURCES
WHERE batch_source_id = p_batch_source_id;
Select legal_entity_id
BULK COLLECT INTO
l_legal_entity_id
from xle_le_ou_ledger_v
where ledger_id = p_sob_id and
operating_unit_id = p_org_id;
Select legal_entity_name
BULK COLLECT INTO
l_legal_entity_name
from xle_le_ou_ledger_v
where ledger_id = p_sob_id and
operating_unit_id = p_org_id;
SELECT USE_LE_AS_SUBSCRIBER_FLAG
INTO l_subscriber_flag
FROM zx_party_tax_profile
WHERE PARTY_TYPE_CODE = 'OU'
AND PARTY_ID = arp_global.sysparam.org_id;
select default_legal_context_id
into l_legal_entity_id
from hr_operating_units
where organization_id = p_org_id;