APPS.XTR_FPS3_P dependencies on XTR_MASTER_CURRENCIES

Line 136: v_gl_calendar_name xtr_master_currencies_v.gl_calendar_name%TYPE;

132: l_level OUT NOCOPY VARCHAR2) is
133: --
134: v_dummy_count number;
135: v_dummy_char varchar2(1);
136: v_gl_calendar_name xtr_master_currencies_v.gl_calendar_name%TYPE;
137: v_nls_adjust number;
138: v_bHasGLCalendar boolean := false;
139:
140: cursor HOL is

Line 146: cursor get_calendar_name(p_currency xtr_master_currencies_v.currency%TYPE) is

142: from XTR_HOLIDAYS
143: where HOLIDAY_DATE =in_date
144: and CURRENCY = l_currency;
145:
146: cursor get_calendar_name(p_currency xtr_master_currencies_v.currency%TYPE) is
147: select gl_calendar_name
148: from xtr_master_currencies
149: where currency=p_currency
150: and authorised='Y';

Line 148: from xtr_master_currencies

144: and CURRENCY = l_currency;
145:
146: cursor get_calendar_name(p_currency xtr_master_currencies_v.currency%TYPE) is
147: select gl_calendar_name
148: from xtr_master_currencies
149: where currency=p_currency
150: and authorised='Y';
151:
152: cursor get_gl_weekend(p_calendar_name gl_transaction_calendar.name%TYPE,

Line 451: from XTR_MASTER_CURRENCIES a

447: or (a.CURRENCY_BUY = l_currency_b and a.CURRENCY_SELL = l_currency_a));
448: --
449: cursor TOL1 is
450: select a.USD_QUOTED_SPOT
451: from XTR_MASTER_CURRENCIES a
452: where a.CURRENCY = l_currency_a;
453: --
454: cursor TOL2 is
455: select a.USD_QUOTED_SPOT

Line 456: from XTR_MASTER_CURRENCIES a

452: where a.CURRENCY = l_currency_a;
453: --
454: cursor TOL2 is
455: select a.USD_QUOTED_SPOT
456: from XTR_MASTER_CURRENCIES a
457: where a.CURRENCY = l_currency_b;
458: --
459: begin
460: if l_tolerance is NOT NULL then