The following lines contain the word 'select', 'insert', 'update' or 'delete':
select '1'
from pqh_process_log
where module_cd = 'POSITION_BUDGET_ANALYSIS'
and information12 = 'REPORT'
and information11 like P_BATCH_NAME||'%';
Select trunc(sysdate)
From dual;
SELECT name
FROM per_organization_structures
WHERE organization_structure_id = p_org_structure_id;
SELECT meaning
FROM hr_lookups
WHERE lookup_type IN ('PQH_BUDGET_ENTITY','UNDER_BDGT_EXTRA_TYPES')
AND lookup_code = p_entity_code;
SELECT bg.legislation_code
FROM per_business_groups_perf bg
WHERE bg.business_group_id = p_business_group_id;
insert into fnd_sessions (session_id, effective_date)
values(userenv('sessionid'),p_effective_date);