APPS.XTR_FPS2_P dependencies on XTR_MASTER_CURRENCIES_V

Line 1131: from XTR_MASTER_CURRENCIES_V s

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 *****/

Line 1852: from XTR_MASTER_CURRENCIES_V

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

Line 1857: from XTR_MASTER_CURRENCIES_V

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;

Line 2158: from XTR_MASTER_CURRENCIES_V

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

Line 2163: from XTR_MASTER_CURRENCIES_V

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;

Line 2562: from XTR_MASTER_CURRENCIES_V

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

Line 2570: from XTR_MASTER_CURRENCIES_V a,

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: