[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select decode(decode(substr(hrl.meaning,1,3),hrl.lookup_code||'_',substr(hrl.meaning,4),hrl.meaning),
'SEGMENT1',pea.segment1,
'SEGMENT2',pea.segment2,
'SEGMENT3',pea.segment3,
'SEGMENT4',pea.segment4,
'SEGMENT5',pea.segment5,
'SEGMENT6',pea.segment6,
'SEGMENT7',pea.segment7,
'SEGMENT8',pea.segment8,
'SEGMENT9',pea.segment9,
'SEGMENT10',pea.segment10,
'SEGMENT11',pea.segment11,
'SEGMENT12',pea.segment12,
'SEGMENT13',pea.segment13,
'SEGMENT14',pea.segment14,
'SEGMENT15',pea.segment15,
'SEGMENT16',pea.segment16,
'SEGMENT17',pea.segment17,
'SEGMENT18',pea.segment18,
'SEGMENT19',pea.segment19,
'SEGMENT20',pea.segment20,
'SEGMENT21',pea.segment21,
'SEGMENT22',pea.segment22,
'SEGMENT23',pea.segment23,
'SEGMENT24',pea.segment24,
'SEGMENT25',pea.segment25,
'SEGMENT26',pea.segment26,
'SEGMENT27',pea.segment27,
'SEGMENT28',pea.segment28,
'SEGMENT29',pea.segment29,
'SEGMENT30',pea.segment30,
'EMPTY')
from pay_external_accounts pea,
hr_lookups hrl
where external_account_id = p_external_account_id
and hrl.lookup_type = p_lookup_type
and hrl.lookup_code = p_legislation_code;
select meaning
into l_bank_name
from hr_lookups
where lookup_code = l_segment_value
and lookup_type = 'GB_BANKS'
and application_id between 800 and 899;
select effective_date
from fnd_sessions
where session_id = userenv('sessionid');
select
hrl.meaning
from
hr_lookups hrl,
pay_ce_reconciled_payments pcrp
where
hrl.lookup_code = pcrp.status_code
and pcrp.assignment_action_id = p_payment_id
and hrl.lookup_type = 'RECON_STATUS';
select decode(substr(p_meaning,1,3),p_code||'_',substr(p_meaning,4),p_meaning)
into l_meaning
from dual;