eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_REVAL_PROCESS_P dependencies on XTR_COMPANY_PARAMETERS

Line 587: from xtr_company_parameters

583: from xtr_batches
584: where BATCH_ID = p_batch_id;
585:
586: select PARAMETER_VALUE_CODE into l_accounting
587: from xtr_company_parameters
588: where COMPANY_CODE = l_company_code and
589: PARAMETER_CODE = C_DEAL_SETTLE_ACCOUNTING;
590:
591: select PARAMETER_VALUE_CODE into l_exchange_type

Line 592: from xtr_company_parameters

588: where COMPANY_CODE = l_company_code and
589: PARAMETER_CODE = C_DEAL_SETTLE_ACCOUNTING;
590:
591: select PARAMETER_VALUE_CODE into l_exchange_type
592: from xtr_company_parameters
593: where COMPANY_CODE = l_company_code and
594: PARAMETER_CODE = C_EXCHANGE_RATE_TYPE;
595:
596: select sob.currency_code

Line 2274: from xtr_company_parameters

2270: l_buf Varchar2(500);
2271: Begin
2272:
2273: select PARAMETER_VALUE_CODE into l_accounting
2274: from xtr_company_parameters
2275: where COMPANY_CODE = rec.company_code and
2276: PARAMETER_CODE = C_DEAL_SETTLE_ACCOUNTING;
2277:
2278: If rec.deal_type = 'FX' then

Line 2452: from xtr_company_parameters

2448: retcode NUMBER;
2449: l_buf Varchar2(500);
2450: Begin
2451: select PARAMETER_VALUE_CODE into l_begin_fv
2452: from xtr_company_parameters
2453: where COMPANY_CODE = rec.company_code and
2454: PARAMETER_CODE = C_BEGIN_FV;
2455:
2456: select rounding_factor

Line 3834: XTR_COMPANY_PARAMETERS CP

3830: r.first_reval_batch_id, r.interest_rate,
3831: r.average_exchange_rate, r.cross_ref_to_trans, r.product_type,
3832: r.currency_exchange_rate, r.accum_int_action, r.accum_interest_bf --bug 2895074
3833: from XTR_ROLLOVER_TRANSACTIONS R,
3834: XTR_COMPANY_PARAMETERS CP
3835: where r.deal_number = rec.deal_no
3836: and cp.company_code = r.company_code
3837: and cp.parameter_code = 'ACCNT_TSDTM'
3838: and decode(cp.parameter_value_code, 'TRADE', r.deal_date,

Line 4223: from xtr_company_parameters

4219:
4220: begin
4221: select PARAMETER_VALUE_CODE -- determine if we are going to include transaction cost in deal type
4222: into l_inclu_cost
4223: from xtr_company_parameters
4224: where company_code = rec.company_code
4225: and parameter_code = C_INCOST;
4226:
4227: if rec.deal_type = 'FRA' then

Line 4448: from XTR_COMPANY_PARAMETERS

4444: /* AW Bug 2184427
4445: -- Also insert ALL_IN_RATE to xtr_rollover_transactions table
4446: select PARAMETER_VALUE_CODE
4447: into l_inclu_cost
4448: from XTR_COMPANY_PARAMETERS
4449: where company_code = p_company_code
4450: and parameter_code = C_INCOST;
4451: */
4452:

Line 4988: from xtr_company_parameters

4984: r_err_log err_log; -- record type
4985:
4986: begin
4987: select PARAMETER_VALUE_CODE into l_discount_date_method
4988: from xtr_company_parameters
4989: where COMPANY_CODE = rec.company_code and
4990: PARAMETER_CODE = C_FRA_DISCOUNT_METHOD;
4991:
4992: l_market_set := rec.market_data_set;

Line 5203: from xtr_company_parameters

5199: End if;
5200:
5201: select PARAMETER_VALUE_CODE
5202: into l_discount_date_method
5203: from xtr_company_parameters
5204: where COMPANY_CODE = rec.company_code and
5205: PARAMETER_CODE = C_FX_DISCOUNT_METHOD;
5206:
5207: select param_value

Line 6261: from xtr_company_parameters

6257: LOG_MSG('Entering procedure xtr_revl_fv_hedge');
6258: -- Check Prospective Tests status
6259: select PARAMETER_VALUE_CODE
6260: into l_test
6261: from xtr_company_parameters
6262: where COMPANY_CODE = rec.company_code and
6263: PARAMETER_CODE = C_BTEST;
6264:
6265: if nvl(l_test, 'N') = 'Y' then

Line 7178: from xtr_company_parameters

7174: retcode NUMBER;
7175:
7176: begin
7177: select PARAMETER_VALUE_CODE into l_discount_date_method
7178: from xtr_company_parameters
7179: where COMPANY_CODE = rec.company_code and
7180: PARAMETER_CODE = C_FUTURE_DATE_NI; -- 'REVAL_FDNDR'
7181:
7182: -- select BALANCE_OUT - INTEREST

Line 7616: XTR_COMPANY_PARAMETERS CP,

7612: bond.amc_real_gain_loss, bond.mtm_real_gain_loss, bond.cross_ref_clean_px,
7613: decode(cp.parameter_value_code, 'TRADE', bond.cross_ref_deal_date,
7614: bond.cross_ref_start_date) resale_rec_date
7615: from XTR_BOND_ALLOC_DETAILS BOND,
7616: XTR_COMPANY_PARAMETERS CP,
7617: XTR_DEALS D
7618: Where bond.deal_no = rec.deal_no
7619: and bond.deal_no = d.deal_no
7620: and bond.batch_id is null

Line 8666: XTR_COMPANY_PARAMETERS CP,

8662: stock.real_gain_loss, stock.quantity, stock.remaining_quantity,
8663: stock.price_per_share, decode(cp.parameter_value_code, 'TRADE',
8664: stock.cross_ref_deal_date, stock.cross_ref_start_date) resale_rec_date
8665: from XTR_STOCK_ALLOC_DETAILS STOCK,
8666: XTR_COMPANY_PARAMETERS CP,
8667: XTR_DEALS D
8668: Where stock.deal_no = rec.deal_no
8669: and stock.deal_no = d.deal_no
8670: and stock.batch_id is null

Line 10304: from xtr_company_parameters

10300: if p_mds is not null then
10301: return;
10302: else
10303: select PARAMETER_VALUE_CODE into p_mds
10304: from xtr_company_parameters
10305: where COMPANY_CODE = rec.company_code and
10306: PARAMETER_CODE = C_MARKET_DATA_SET;
10307: end if;
10308: