APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_MASTER_CURRENCIES_V

Line 445: from XTR_MASTER_CURRENCIES_V

441: function VALID_CURRENCY(p_curr IN VARCHAR2) return boolean is
442: -----------------------------------------------------------------------------------------------------
443: cursor curs(c_curr IN VARCHAR2) is
444: select ig_year_basis
445: from XTR_MASTER_CURRENCIES_V
446: where currency = c_curr
447: and nvl(authorised, 'N') = 'Y';
448:
449:

Line 812: xtr_MASTER_CURRENCIES_v m

808: -----------------------------------------------------------------------------------------------------
809: cursor RND_FAC is
810: select 'Y'
811: from xtr_PARTIES_v p,
812: xtr_MASTER_CURRENCIES_v m
813: where p.PARTY_CODE = p_comp
814: and m.CURRENCY = p.HOME_CURRENCY;
815:
816: l_dummy VARCHAR2(1);

Line 1093: from xtr_MASTER_CURRENCIES_v

1089:
1090: --
1091: cursor RND_YR is
1092: select ROUNDING_FACTOR
1093: from xtr_MASTER_CURRENCIES_v
1094: where CURRENCY = G_Ig_Main_Rec.CURRENCY;
1095: --
1096: cursor LATEST_DATE is
1097: select a.TRANSFER_DATE,

Line 1275: xtr_MASTER_CURRENCIES_v m

1271:
1272: cursor RND_FAC is
1273: select m.ROUNDING_FACTOR
1274: from xtr_PARTIES_v p,
1275: xtr_MASTER_CURRENCIES_v m
1276: where p.PARTY_CODE = G_Ig_Main_Rec.COMPANY_CODE
1277: and m.CURRENCY = p.HOME_CURRENCY;
1278:
1279: cursor HCE_AMT is

Line 1284: from xtr_MASTER_CURRENCIES_v s

1280: select nvl(round((nvl(G_Ig_Main_Rec.INTEREST,0) / s.hce_rate),roundfac),0),
1281: nvl(round((G_Ig_Main_Rec.PRINCIPAL_ADJUST / s.hce_rate),roundfac),0),
1282: nvl(round((G_Ig_Main_Rec.BALANCE_OUT / s.hce_rate),roundfac),0),
1283: nvl(round((nvl(G_Ig_Main_Rec.INTEREST_SETTLED,0) / s.hce_rate),roundfac),0)
1284: from xtr_MASTER_CURRENCIES_v s
1285: where s.CURRENCY = G_Ig_Main_Rec.CURRENCY;
1286:
1287: begin
1288:

Line 2387: from xtr_MASTER_CURRENCIES_V a,

2383: select a.hce_rate,
2384: a.rounding_factor,
2385: a.ig_year_basis,
2386: m.rounding_factor
2387: from xtr_MASTER_CURRENCIES_V a,
2388: xtr_PARTIES_V p,
2389: xtr_MASTER_CURRENCIES_V m
2390: where a.CURRENCY = p_currency
2391: and p.PARTY_CODE = p_company_code

Line 2389: xtr_MASTER_CURRENCIES_V m

2385: a.ig_year_basis,
2386: m.rounding_factor
2387: from xtr_MASTER_CURRENCIES_V a,
2388: xtr_PARTIES_V p,
2389: xtr_MASTER_CURRENCIES_V m
2390: where a.CURRENCY = p_currency
2391: and p.PARTY_CODE = p_company_code
2392: and m.CURRENCY = p.HOME_CURRENCY;
2393: --