DBA Data[Home] [Help]

APPS.XTR_FPS3_P dependencies on XTR_MASTER_CURRENCIES_V

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';