The following lines contain the word 'select', 'insert', 'update' or 'delete':
select base_rate
from xtr_deals
where deal_no=to_number(p_deal_number);
select internal_ticket_no
from xtr_deals
where deal_no=to_number(p_deal_number);
select internal_ticket_no
from xtr_rollover_transactions
where deal_number=to_number(p_deal_number)
and transaction_number=p_transaction_number;
select journal_date
from xtr_journals
where deal_type=p_deal_type and
deal_number=p_deal_number and
amount_type in ('INTSET','COMPOND') and
journal_date < p_journal_date and
accounted_dr <>0
order by journal_date desc;
select sum(ACCOUNTED_DR)
from xtr_journals
where deal_type=p_deal_type and
deal_number=p_deal_number and
amount_type ='INTADJ' and
journal_date > p_prev_journal_date and
journal_date <= p_journal_date and
accounted_dr <>0;
select journal_date
from xtr_journals
where deal_type=p_deal_type and
deal_number=p_deal_number and
amount_type ='INTSET' and
accounted_dr <> 0 and
journal_date < p_journal_date and
transaction_number in (select a.transaction_number from xtr_rollover_transactions a
where a.deal_number=p_deal_number
start with a.cross_ref_to_trans = p_transaction_number
connect by (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number))
order by journal_date desc;
select sum(ACCOUNTED_DR)
from xtr_journals
where deal_type=p_deal_type and
deal_number=p_deal_number and
amount_type ='INTADJ' and
journal_date > l_prev_journal_date and
journal_date <= p_journal_date and
accounted_dr <> 0 and
transaction_number in (select a.transaction_number from xtr_rollover_transactions a
where a.deal_number=p_deal_number
start with a.cross_ref_to_trans = p_transaction_number
connect by (a.deal_number = PRIOR a.deal_number and a.cross_ref_to_trans = PRIOR a.transaction_number));