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 2257: from xtr_company_parameters

2253: l_buf Varchar2(500);
2254: Begin
2255:
2256: select PARAMETER_VALUE_CODE into l_accounting
2257: from xtr_company_parameters
2258: where COMPANY_CODE = rec.company_code and
2259: PARAMETER_CODE = C_DEAL_SETTLE_ACCOUNTING;
2260:
2261: If rec.deal_type = 'FX' then

Line 2435: from xtr_company_parameters

2431: retcode NUMBER;
2432: l_buf Varchar2(500);
2433: Begin
2434: select PARAMETER_VALUE_CODE into l_begin_fv
2435: from xtr_company_parameters
2436: where COMPANY_CODE = rec.company_code and
2437: PARAMETER_CODE = C_BEGIN_FV;
2438:
2439: select rounding_factor

Line 3817: XTR_COMPANY_PARAMETERS CP

3813: r.first_reval_batch_id, r.interest_rate,
3814: r.average_exchange_rate, r.cross_ref_to_trans, r.product_type,
3815: r.currency_exchange_rate, r.accum_int_action, r.accum_interest_bf --bug 2895074
3816: from XTR_ROLLOVER_TRANSACTIONS R,
3817: XTR_COMPANY_PARAMETERS CP
3818: where r.deal_number = rec.deal_no
3819: and cp.company_code = r.company_code
3820: and cp.parameter_code = 'ACCNT_TSDTM'
3821: and decode(cp.parameter_value_code, 'TRADE', r.deal_date,

Line 4206: from xtr_company_parameters

4202:
4203: begin
4204: select PARAMETER_VALUE_CODE -- determine if we are going to include transaction cost in deal type
4205: into l_inclu_cost
4206: from xtr_company_parameters
4207: where company_code = rec.company_code
4208: and parameter_code = C_INCOST;
4209:
4210: if rec.deal_type = 'FRA' then

Line 4431: from XTR_COMPANY_PARAMETERS

4427: /* AW Bug 2184427
4428: -- Also insert ALL_IN_RATE to xtr_rollover_transactions table
4429: select PARAMETER_VALUE_CODE
4430: into l_inclu_cost
4431: from XTR_COMPANY_PARAMETERS
4432: where company_code = p_company_code
4433: and parameter_code = C_INCOST;
4434: */
4435:

Line 4971: from xtr_company_parameters

4967: r_err_log err_log; -- record type
4968:
4969: begin
4970: select PARAMETER_VALUE_CODE into l_discount_date_method
4971: from xtr_company_parameters
4972: where COMPANY_CODE = rec.company_code and
4973: PARAMETER_CODE = C_FRA_DISCOUNT_METHOD;
4974:
4975: l_market_set := rec.market_data_set;

Line 5186: from xtr_company_parameters

5182: End if;
5183:
5184: select PARAMETER_VALUE_CODE
5185: into l_discount_date_method
5186: from xtr_company_parameters
5187: where COMPANY_CODE = rec.company_code and
5188: PARAMETER_CODE = C_FX_DISCOUNT_METHOD;
5189:
5190: select param_value

Line 6244: from xtr_company_parameters

6240: LOG_MSG('Entering procedure xtr_revl_fv_hedge');
6241: -- Check Prospective Tests status
6242: select PARAMETER_VALUE_CODE
6243: into l_test
6244: from xtr_company_parameters
6245: where COMPANY_CODE = rec.company_code and
6246: PARAMETER_CODE = C_BTEST;
6247:
6248: if nvl(l_test, 'N') = 'Y' then

Line 7159: from xtr_company_parameters

7155: retcode NUMBER;
7156:
7157: begin
7158: select PARAMETER_VALUE_CODE into l_discount_date_method
7159: from xtr_company_parameters
7160: where COMPANY_CODE = rec.company_code and
7161: PARAMETER_CODE = C_FUTURE_DATE_NI; -- 'REVAL_FDNDR'
7162:
7163: -- select BALANCE_OUT - INTEREST

Line 7597: XTR_COMPANY_PARAMETERS CP,

7593: bond.amc_real_gain_loss, bond.mtm_real_gain_loss, bond.cross_ref_clean_px,
7594: decode(cp.parameter_value_code, 'TRADE', bond.cross_ref_deal_date,
7595: bond.cross_ref_start_date) resale_rec_date
7596: from XTR_BOND_ALLOC_DETAILS BOND,
7597: XTR_COMPANY_PARAMETERS CP,
7598: XTR_DEALS D
7599: Where bond.deal_no = rec.deal_no
7600: and bond.deal_no = d.deal_no
7601: and bond.batch_id is null

Line 8647: XTR_COMPANY_PARAMETERS CP,

8643: stock.real_gain_loss, stock.quantity, stock.remaining_quantity,
8644: stock.price_per_share, decode(cp.parameter_value_code, 'TRADE',
8645: stock.cross_ref_deal_date, stock.cross_ref_start_date) resale_rec_date
8646: from XTR_STOCK_ALLOC_DETAILS STOCK,
8647: XTR_COMPANY_PARAMETERS CP,
8648: XTR_DEALS D
8649: Where stock.deal_no = rec.deal_no
8650: and stock.deal_no = d.deal_no
8651: and stock.batch_id is null

Line 10285: from xtr_company_parameters

10281: if p_mds is not null then
10282: return;
10283: else
10284: select PARAMETER_VALUE_CODE into p_mds
10285: from xtr_company_parameters
10286: where COMPANY_CODE = rec.company_code and
10287: PARAMETER_CODE = C_MARKET_DATA_SET;
10288: end if;
10289: