APPS.AP_APXMTDCR_XMLP_PKG dependencies on FND_CURRENCIES_VL

Line 67: fnd_currencies_vl c

63: INTO l_base_curr,
64: l_prec,
65: l_min_au
66: FROM ap_system_parameters p,
67: fnd_currencies_vl c
68: WHERE p.base_currency_code = c.currency_code;
69:
70: c_base_currency_code := l_base_curr;
71: c_base_precision := l_prec;

Line 216: FROM fnd_currencies_vl c1, fnd_currencies_vl c2

212: BEGIN
213: SELECT c1.currency_code, c1.name, c2.name
214: INTO l_currency, l_currency_name,
215: l_pay_currency_name
216: FROM fnd_currencies_vl c1, fnd_currencies_vl c2
217: WHERE c1.currency_code = currency_code_1
218: AND c2.currency_code = pay_currency_code;
219:
220: return (TRUE);

Line 247: l_currency_desc fnd_currencies_vl.name%TYPE;

243: function c_currency_descformula(c_currency_code in varchar2) return varchar2 is
244: begin
245:
246: DECLARE
247: l_currency_desc fnd_currencies_vl.name%TYPE;
248: BEGIN
249: SELECT c.name
250: INTO l_currency_desc
251: FROM fnd_currencies_vl c

Line 251: FROM fnd_currencies_vl c

247: l_currency_desc fnd_currencies_vl.name%TYPE;
248: BEGIN
249: SELECT c.name
250: INTO l_currency_desc
251: FROM fnd_currencies_vl c
252: WHERE c.currency_code = c_currency_code;
253: return(l_currency_desc);
254: EXCEPTION
255: WHEN OTHERS THEN null;

Line 263: l_currency_desc fnd_currencies_vl.name%TYPE;

259: function c_pay_currency_descformula(c_pay_currency_code in varchar2) return varchar2 is
260: begin
261:
262: DECLARE
263: l_currency_desc fnd_currencies_vl.name%TYPE;
264: BEGIN
265: SELECT c.name
266: INTO l_currency_desc
267: FROM fnd_currencies_vl c

Line 267: FROM fnd_currencies_vl c

263: l_currency_desc fnd_currencies_vl.name%TYPE;
264: BEGIN
265: SELECT c.name
266: INTO l_currency_desc
267: FROM fnd_currencies_vl c
268: WHERE c.currency_code = c_pay_currency_code ;
269: return(l_currency_desc);
270: EXCEPTION
271: WHEN OTHERS THEN null;