The following lines contain the word 'select', 'insert', 'update' or 'delete':
select source_id
from jtf_rs_resource_extns
where resource_id = p_resource_id;
select lookup_code, meaning from fnd_lookup_values
where lookup_type = 'IEX_UWQ_NODE_STATUS'
and lookup_code in ('ACTIVE', 'PENDING') -- added by jypark 01/02/2003 not show 'COMPLETE' node
and LANGUAGE = userenv('LANG');
SELECT meaning
FROM fnd_lookup_values
WHERE lookup_type = in_lookup_type
AND lookup_code = in_lookup_code
AND LANGUAGE = userenv('LANG');
SELECT work_q_view_for_primary_node, work_q_label_lu_type, work_q_label_lu_code
FROM ieu_uwq_sel_enumerators
WHERE sel_enum_id = in_sel_enum_id;
CURSOR C_ORG_ID IS SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y';
SELECT PREFERENCE_VALUE
FROM IEX_APP_PREFERENCES_B
WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL'
and org_id is null--Modified for Bug 9079394 by barathsr 03-Nov-2009
and enabled_flag='Y'; --bug#6717849 schekuri 31-Jul-2009
is select lookup_code
from iex_lookups_v
where lookup_type='IEX_RUNNING_LEVEL'
and lookup_code= p_multi_level
and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
' = GLSOB.SET_OF_BOOKS_ID');
L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
select count(1)
into l_level_count
from iex_lookups_v
where lookup_type='IEX_RUNNING_LEVEL'
and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
l_str_bkr := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.party_id) ' ;
l_str_bkr_2 := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.customer_id) ' ;
' IN (select iea.alt_resource_id '||
' FROM iex_assignments iea ' ||
' WHERE nvl(iea.deleted_flag,''N'') = ''N'' ' ||
' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
' AND iea.resource_id = ' || l_sel_enum_rec.work_q_view_for_primary_node ||'.RESOURCE_ID ) ' ;
l_restrict_assign_resource := ' select iea.alt_resource_id '||
' FROM hz_customer_profiles hp, ar_collectors ac, ' ||
' iex_assignments iea ' ||
' WHERE hp.collector_id = ac.collector_id ' ||
' AND ac.resource_id = iea.alt_resource_id ' ||
' AND iea.alt_employee_id = :PERSON_ID ' ||
' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) ' ||
' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) ' ||
' AND ac.resource_id IS NOT NULL ';
l_restrict_res_grp := ' select ac.resource_id '||
' FROM hz_customer_profiles hp, ar_collectors ac ' ||
' WHERE hp.collector_id = ac.collector_id ' ||
' AND ac.employee_id = :PERSON_ID ' ||
' AND ac.resource_type = ''RS_RESOURCE'' ' ||
' AND ac.resource_id IS NOT NULL ' ||
' UNION ALL SELECT jtgrp.resource_id ' ||
' FROM hz_customer_profiles hp, ar_collectors ac , jtf_rs_group_members jtgrp ' ||
' WHERE hp.collector_id = ac.collector_id ' ||
' AND ac.resource_ID = jtgrp.group_id ' ||
' AND ac.resource_type = ''RS_GROUP'' ' ||
' AND ac.resource_id IS NOT NULL ' ||
' AND NVL(jtgrp.delete_flag,''N'') = ''N'' ' ||
' AND jtgrp.resource_id = :RESOURCE_ID ' ||
' AND ' || l_sel_enum_rec.work_q_view_for_primary_node ||
'.resource_id = :RESOURCE_ID ' ||
' AND jtgrp.PERSON_ID = :PERSON_ID ';
l_str_bkr := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.customer_id and NVL(BKR.DISPOSITION_CODE,''GRANTED'') in (''GRANTED'',''NEGOTIATION'') ) ' ;
l_str_bkr := ' AND NOT EXISTS (SELECT 1 FROM iex_bankruptcies bkr WHERE bkr.party_id = ' || l_sel_enum_rec.work_q_view_for_primary_node || '.party_id and NVL(BKR.DISPOSITION_CODE,''GRANTED'') in (''GRANTED'',''NEGOTIATION'') ) ' ;
SELECT count(*) into l_check from iex_assignments where
alt_resource_id = p_RESOURCE_ID
AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
AND TRUNC(NVL(END_DATE,SYSDATE)) >= TRUNC(SYSDATE)
AND NVL(DELETED_FLAG,'N') = 'N';
-- l_restrict_assign_resource := l_restrict_assign_resource || ' and resource_id in (select resource_id from ar_collectors where '
-- || ' resource_type = ''RS_RESOURCE'' and resource_id = :RESOURCE_ID ';
l_restrict_assign_resource := l_restrict_assign_resource||' and resource_id in (select :RESOURCE_ID+0 from dual '; --Added for bug#7499019 by PNAVEENK
' union all (SELECT iea.resource_id FROM iex_assignments iea where '||
' iea.alt_employee_id = :PERSON_ID '||
' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' ))';
' union all (SELECT iea.resource_id FROM iex_assignments iea where '||
' iea.alt_employee_id = :PERSON_ID '||
' AND TRUNC(iea.START_DATE) <= TRUNC(SYSDATE) '||
' AND TRUNC(NVL(iea.END_DATE,SYSDATE)) >= TRUNC(SYSDATE) '||
' AND NVL(iea.DELETED_FLAG,''N'') = ''N'' ))';