[Home] [Help]
41: decode(sr2.currency_a,'USD',sr2.ask_price, (1/sr2.bid_price)) /
42: decode(sr3.currency_a, 'USD', sr3.bid_price, (1/sr3.ask_price))
43: tmp_offer_rate,
44: nvl(sr1.rate_date,sr1.spot_date) tmp_rate_date
45: from XTR_MASTER_CURRENCIES sr1,
46: XTR_MARKET_PRICES sr2,
47: XTR_MARKET_PRICES sr3
48: where sr1.currency = quoted_1st
49: and (sr2.currency_a = 'USD' or sr2.currency_b = 'USD')
213: /* Modified below cursors Bug 4647357
214: cursor COMP_DFLT is
215: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
216: from XTR_PARTIES_V a,
217: XTR_MASTER_CURRENCIES b,
218: HR_LEGAL_ENTITIES c,
219: GL_SETS_OF_BOOKS d
220: where a.PARTY_TYPE = 'C'
221: and a.DEFAULT_COMPANY = 'Y'
225: --
226: cursor COMP_CCY is
227: select d.CURRENCY_CODE, b.NAME
228: from XTR_PARTIES_V a,
229: XTR_MASTER_CURRENCIES b,
230: HR_LEGAL_ENTITIES c,
231: GL_SETS_OF_BOOKS d
232: where a.PARTY_TYPE = 'C'
233: and a.PARTY_CODE = l_comp
237: */
238: cursor COMP_DFLT is
239: select a.PARTY_CODE, a.SHORT_NAME, d.CURRENCY_CODE, b.NAME
240: from XTR_PARTIES_V a,
241: XTR_MASTER_CURRENCIES b,
242: GL_LEDGER_LE_V c,
243: GL_SETS_OF_BOOKS d
244: where a.PARTY_TYPE = 'C'
245: and a.DEFAULT_COMPANY = 'Y'
250: --
251: cursor COMP_CCY is
252: select d.CURRENCY_CODE, b.NAME
253: from XTR_PARTIES_V a,
254: XTR_MASTER_CURRENCIES b,
255: GL_LEDGER_LE_V c,
256: GL_SETS_OF_BOOKS d
257: where a.PARTY_TYPE = 'C'
258: and a.PARTY_CODE = l_comp
291: l_ccy_name IN OUT NOCOPY VARCHAR2) is
292: cursor DFLT is
293: select a.HOME_CURRENCY,b.NAME
294: from XTR_PARTIES_V a,
295: XTR_MASTER_CURRENCIES b
296: where a.PARTY_CODE = l_pty
297: and b.CURRENCY = a.HOME_CURRENCY;
298: --
299: begin
1127: v_party_type Xtr_Parties_V.Party_Type%Type;
1128:
1129: cursor CALC_HCE_AMTS is
1130: select round(abs(p_one_step_rec.p_amount) / s.HCE_RATE,2)
1131: from XTR_MASTER_CURRENCIES_V s
1132: where s.CURRENCY = upper(p_one_step_rec.p_CURRENCY);
1133:
1134: BEGIN
1135: /**** for a given schedule code what is the tax settle method defined in setup is derived here *****/
1848:
1849: l_currency VARCHAR2(15);
1850: cursor RND_YR_TMM is
1851: select rounding_factor, hce_rate
1852: from XTR_MASTER_CURRENCIES_V
1853: where currency = pmt.currency;
1854:
1855: cursor RND_YR_IRS is
1856: select rounding_factor, hce_rate
1853: where currency = pmt.currency;
1854:
1855: cursor RND_YR_IRS is
1856: select rounding_factor, hce_rate
1857: from XTR_MASTER_CURRENCIES_V
1858: where currency = l_currency;
1859:
1860: l_no_of_days NUMBER;
1861: l_year_basis NUMBER;
2154: pms IRS_ROLL%ROWTYPE;
2155:
2156: cursor RND_YR_TMM is
2157: select rounding_factor, hce_rate
2158: from XTR_MASTER_CURRENCIES_V
2159: where currency = pmt.currency;
2160:
2161: cursor RND_YR_IRS is
2162: select rounding_factor, hce_rate
2159: where currency = pmt.currency;
2160:
2161: cursor RND_YR_IRS is
2162: select rounding_factor, hce_rate
2163: from XTR_MASTER_CURRENCIES_V
2164: where currency = pms.currency;
2165:
2166: l_interest NUMBER;
2167: l_accum_int NUMBER;
2558: -- Get rounding currency and hce_rate
2559: --------------------------------------------
2560: cursor ROUND_FACTOR (l_ccy VARCHAR2) is
2561: select hce_rate
2562: from XTR_MASTER_CURRENCIES_V
2563: where currency = l_ccy;
2564:
2565: --------------------------------------------
2566: -- Get home rounding curency
2566: -- Get home rounding curency
2567: --------------------------------------------
2568: cursor HCE_ROUND_FACTOR is
2569: select a.rounding_factor
2570: from XTR_MASTER_CURRENCIES_V a,
2571: XTR_PRO_PARAM b
2572: where b.param_name = 'SYSTEM_FUNCTIONAL_CCY'
2573: and a.currency = param_value;
2574: