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_NI_TRANSFERS_PKG dependencies on XTR_MASTER_CURRENCIES_V

Line 902: from xtr_master_currencies_v

898: l_count NUMBER;
899: BEGIN
900: Select count(*)
901: Into l_count
902: from xtr_master_currencies_v
903: where nvl(authorised,'N') = 'Y'
904: And currency = p_currency;
905:
906: return (l_count>0);

Line 1926: from xtr_master_currencies_v m

1922: roundfac number(3,2);
1923:
1924: cursor rnd(p_curr in VARCHAR2) is
1925: select m.rounding_factor
1926: from xtr_master_currencies_v m
1927: where m.currency = p_curr;
1928:
1929:
1930: begin

Line 2003: from xtr_MASTER_CURRENCIES_v m

1999:
2000:
2001: cursor HCE is
2002: select nvl(m.HCE_RATE,1)
2003: from xtr_MASTER_CURRENCIES_v m
2004: where m.CURRENCY = G_Ni_Main_Rec.CURRENCY;
2005:
2006: cursor RND_FAC is
2007: select m.ROUNDING_FACTOR

Line 2009: xtr_MASTER_CURRENCIES_v m

2005:
2006: cursor RND_FAC is
2007: select m.ROUNDING_FACTOR
2008: from xtr_PARTIES_v p,
2009: xtr_MASTER_CURRENCIES_v m
2010: where p.PARTY_CODE = G_Ni_Main_Rec.COMPANY_CODE
2011: and p.PARTY_TYPE = 'C'
2012: and m.CURRENCY = p.HOME_CURRENCY;
2013:

Line 2023: L_ROUNDING_FACTOR XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;

2019: V_FACE_VALUE_AMOUNT FACE_VALUE_AMOUNT_TYPE;
2020: V_INTEREST INTEREST_TYPE;
2021: V_ORIGINAL_AMOUNT ORIGINAL_AMOUNT_TYPE;
2022:
2023: L_ROUNDING_FACTOR XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
2024:
2025: G_TOTAL_SIZE NUMBER := 0;
2026: G_TOTAL_FACE_VALUE_AMOUNT NUMBER := 0;
2027: G_TOTAL_CONSIDERATION NUMBER := 0;

Line 2337: from xtr_MASTER_CURRENCIES_v m

2333: RETURN NUMBER IS
2334: --
2335: cursor RND_FAC(p_ccy VARCHAR2) is
2336: select nvl(m.ROUNDING_FACTOR,2)
2337: from xtr_MASTER_CURRENCIES_v m
2338: where m.CURRENCY = p_ccy;
2339: --
2340: cursor get_rounding_rules(p_tax_code VARCHAR2) is
2341: select tax_rounding_rule,tax_rounding_precision

Line 2535: xtr_master_currencies_v m

2531:
2532: cursor rnd_fac is
2533: select m.rounding_factor
2534: from xtr_parties_v p,
2535: xtr_master_currencies_v m
2536: where p.party_code = G_Ni_Main_Rec.company_code
2537: and p.party_type = 'C'
2538: and m.currency = p.home_currency;
2539:

Line 2545: from XTR_MASTER_CURRENCIES_v s

2541: select round((G_Ni_Main_Rec.START_AMOUNT / nvl(s.HCE_RATE,1)),nvl(l_roundfac,2)),
2542: round((G_Ni_Main_Rec.MATURITY_AMOUNT / nvl(s.HCE_RATE,1)),nvl(l_roundfac,2)),
2543: round((G_Ni_Main_Rec.INTEREST_AMOUNT / nvl(s.HCE_RATE,1)),nvl(l_roundfac,2)),
2544: round((nvl(G_Ni_Main_Rec.BROKERAGE_AMOUNT,0) / nvl(s.HCE_RATE,1)),nvl(l_roundfac,2))
2545: from XTR_MASTER_CURRENCIES_v s
2546: where s.CURRENCY = G_Ni_Main_Rec.CURRENCY;
2547:
2548: begin
2549: open RND_FAC;

Line 2724: from XTR_MASTER_CURRENCIES_v a,

2720:
2721: cursor CUR_ROUND is
2722: select nvl(a.ROUNDING_FACTOR,2),
2723: nvl(b.ROUNDING_FACTOR,2)
2724: from XTR_MASTER_CURRENCIES_v a,
2725: xtr_MASTER_CURRENCIES_v b,
2726: xtr_PARTIES_v p
2727: where a.CURRENCY = G_Ni_Main_Rec.CURRENCY
2728: and p.PARTY_CODE = G_Ni_Main_Rec.COMPANY_CODE

Line 2725: xtr_MASTER_CURRENCIES_v b,

2721: cursor CUR_ROUND is
2722: select nvl(a.ROUNDING_FACTOR,2),
2723: nvl(b.ROUNDING_FACTOR,2)
2724: from XTR_MASTER_CURRENCIES_v a,
2725: xtr_MASTER_CURRENCIES_v b,
2726: xtr_PARTIES_v p
2727: where a.CURRENCY = G_Ni_Main_Rec.CURRENCY
2728: and p.PARTY_CODE = G_Ni_Main_Rec.COMPANY_CODE
2729: and p.PARTY_TYPE = 'C'