[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select NULL NAME,LIMIT_WEIGHTING,TOLERANCE
from XTR_DEAL_SUBTYPES
where DEAL_TYPE = l_deal_type
and DEAL_SUBTYPE = l_deal_subtype;
select *
from gl_transaction_calendar
where name=p_calendar_name;
select transaction_date
from gl_transaction_dates
where transaction_calendar_id = p_calendar.transaction_calendar_id
and business_day_flag = 'N'
-- The following code converts to an american week where Sun=1 to match GL calendar setup
and 'Y'=decode(((to_char(transaction_date,'D'))-1),
p_sun,p_calendar.sun_business_day_flag,
p_mon,p_calendar.mon_business_day_flag,
p_tue,p_calendar.tue_business_day_flag,
p_wed,p_calendar.wed_business_day_flag,
p_thu,p_calendar.thu_business_day_flag,
p_fri,p_calendar.fri_business_day_flag,
p_sat,p_calendar.sat_business_day_flag)
and not exists (
select holiday_date
from xtr_holidays
where currency=p_currency
and holiday_date=transaction_date);
select XTR_HOLIDAYS_S.nextval
into v_holiday_seq
from dual;
insert into xtr_holidays(
comments,
currency,
day_desc,
holiday_date,
hol_seq)
values (
'IG Imported Holiday',
p_currency_in,
gl_holiday.transaction_date,
gl_holiday.transaction_date,
v_holiday_seq);
select count(*)
from XTR_HOLIDAYS
where HOLIDAY_DATE =in_date
and CURRENCY = l_currency;
select gl_calendar_name
from xtr_master_currencies
where currency=p_currency
and authorised='Y';
select decode(((to_char(p_date,'D'))-1),
p_sun,sun_business_day_flag,
p_mon,mon_business_day_flag,
p_tue,tue_business_day_flag,
p_wed,wed_business_day_flag,
p_thu,thu_business_day_flag,
p_fri,fri_business_day_flag,
p_sat,sat_business_day_flag)
from gl_transaction_calendar
where name = p_calendar_name;
select 1
from xtr_portfolio_deal_amounts
where company_code = l_company_code
and deal_number = l_deal_number;
select NULL NAME
from XTR_PORTFOLIOS
where PORTFOLIO = l_portfolio_code
and COMPANY_CODE = l_company_code;
select 1
from XTR_PORTFOLIO_DEAL_AMOUNTS
where DEAL_NUMBER = l_deal_number
and PORTFOLIO_CODE = l_portfolio_code;
select 1
from XTR_BANK_ACCOUNTS
where PARTY_CODE = l_company_code
and CURRENCY = l_currency;
select PARAM_VALUE
from XTR_PRO_PARAM
where PARAM_NAME = l_p_name
and PARAM_TYPE = 'PRINTER';
select 1
from XTR_ROLLOVER_TRANSACTIONS_V
where START_DATE = l_start_date
and DEAL_NUMBER = l_deal_number;
l_statcode_updateable IN OUT NOCOPY VARCHAR2,
l_err_code OUT NOCOPY NUMBER,
l_level OUT NOCOPY VARCHAR2) is
--
cursor STATUS is
select NULL DESCRIPTION, UPDATEABLE
from XTR_DEAL_STATUSES
where STATUS_CODE = l_status_code
and DEAL_TYPE = l_deal_type
and AUTO_USER_SET = decode(l_record_status,'QUERY',
AUTO_USER_SET,'U');
fetch STATUS INTO l_status_name, l_statcode_updateable;
select a.CURRENCY_FIRST
from XTR_BUY_SELL_COMBINATIONS a
where ((a.CURRENCY_BUY = l_currency_a and a.CURRENCY_SELL = l_currency_b)
or (a.CURRENCY_BUY = l_currency_b and a.CURRENCY_SELL = l_currency_a));
select a.USD_QUOTED_SPOT
from XTR_MASTER_CURRENCIES a
where a.CURRENCY = l_currency_a;
select a.USD_QUOTED_SPOT
from XTR_MASTER_CURRENCIES a
where a.CURRENCY = l_currency_b;
select (a.BID_PRICE + a.ASK_PRICE) / 2
from XTR_MARKET_PRICES a
where a.CURRENCY_A = l_currency
and ((a.NOS_OF_DAYS <= l_period and nvl(l_unique_id,'%') = '%'
and a.NOS_OF_DAYS <> 0 and a.TERM_TYPE NOT IN('S','F','W','V','O')) or
(a.RIC_CODE = l_unique_id and nvl(l_unique_id,'%') <> '%'))
order by NOS_OF_DAYS desc;
select RANGE -- range is nos of days max period contract can go out until
from XTR_TIME_RESTRICTIONS
where DEAL_TYPE = l_deal_type
and (DEAL_SUBTYPE = l_deal_subtype or DEAL_SUBTYPE is NULL)
and (SECURITY_NAME = l_product_type or SECURITY_NAME is NULL)
and (CPARTY_CODE = l_cparty_code or CPARTY_CODE is NULL)
order by CPARTY_CODE asc,SECURITY_NAME asc,DEAL_SUBTYPE asc;
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and dda.settle='Y'
and rt.deal_type='BOND'
and dda.deal_number=0
and dda.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and dda.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and dda.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and dda.settle='Y'
and rt.deal_type='BOND'
and dda.deal_number=rt.deal_number
and dda.transaction_number=rt.transaction_number
and dda.deal_type='BOND';
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and dda.settle='Y'
and rt.deal_type='BOND'
and dda.deal_number=0
and dda.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and dda.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and dda.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and dda.settle='Y'
and rt.deal_type='BOND'
and dda.deal_number=rt.deal_number
and dda.transaction_number=rt.transaction_number
and dda.deal_type='BOND';
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and j.orig_journal_date is not null
and rt.deal_type='BOND'
and j.deal_number=rt.deal_number
and j.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and j.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and j.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and j.orig_journal_date is not null
and rt.deal_type='BOND'
and j.deal_type=rt.deal_type
and rt.deal_number=j.deal_number
and rt.transaction_number=j.transaction_number;
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and j.orig_journal_date is not null
and rt.deal_type='BOND'
and j.deal_number=rt.deal_number
and j.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and j.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and j.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_journals j
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and j.orig_journal_date is not null
and rt.deal_type='BOND'
and j.deal_type=rt.deal_type
and rt.deal_number=j.deal_number
and rt.transaction_number=j.transaction_number;
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and dda.reconciled_reference is not null
and rt.deal_type='BOND'
and dda.deal_number=0
and dda.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and dda.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and dda.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date
and dda.reconciled_reference is not null
and rt.deal_type='BOND'
and dda.deal_number=rt.deal_number
and dda.transaction_number=rt.transaction_number
and dda.deal_type='BOND';
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and dda.reconciled_reference is not null
and rt.deal_type='BOND'
and dda.deal_number=0
and dda.deal_type='EXP'
and ((rt.tax_settled_reference is not null
and dda.transaction_number=rt.tax_settled_reference)
or (rt.principal_tax_settled_ref is not null
and dda.transaction_number=rt.principal_tax_settled_ref))
UNION ALL
select 1
from xtr_deals d, xtr_rollover_transactions rt, xtr_deal_date_amounts dda
where rt.deal_number=d.deal_no
and d.bond_issue=p_bond_issue_code
and dda.reconciled_reference is not null
and rt.deal_type='BOND'
and dda.deal_number=rt.deal_number
and dda.transaction_number=rt.transaction_number
and dda.deal_type='BOND';
select 1
from xtr_rollover_transactions rt, xtr_accrls_amort a, xtr_deals d
where rt.deal_number=a.deal_no
and rt.transaction_number=a.trans_no
and d.deal_no=rt.deal_number
and d.bond_issue=p_bond_issue_code
and rt.maturity_date=p_coupon_date;
select 1
from xtr_accrls_amort a, xtr_deals d
where amount_type='CPMADJ'
and d.deal_no=a.deal_no
and d.bond_issue=p_bond_issue_code;