The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT application_id
INTO l_application_id
FROM fnd_application
WHERE application_short_name = IA_WF_UTIL_PKG.ApplicationShortName;
select nvl(rd.enable_transfer_flag,'N')
,nvl(rd.allow_transaction_date_flag,'N')
,nvl(rd.responsibility_type,IA_WF_UTIL_PKG.RespTypeRequest)
,nvl(rd.require_superuser_flag,'N')
,nvl(rd.approval_type,IA_WF_UTIL_PKG.ApprovalTypeAll)
,nvl(rd.approval_method,IA_WF_UTIL_PKG.ApprovalMethodCostCenter)
into TransferEnabled
,TransactionDateAllowed
,ResponsibilityType
,SuperUserApprovalRequired
,ApprovalType
,ApprovalMethod
from ia_rule_details rd
where rd.rule_id=p_rule_id
and rd.book_type_code=p_book_type_code;
select flv.meaning
into l_meaning
from fnd_lookup_values flv
where flv.lookup_type=p_lookup_type
and flv.lookup_code=p_lookup_code
and flv.view_application_id=205 -- IA application id
and flv.language=nvl(userenv('LANG'),'US')
and flv.security_group_id =
fnd_global.lookup_security_group
(flv.lookup_type
,flv.view_application_id
);