APPS.AP_WEB_DB_COUNTRY_PKG dependencies on FND_CURRENCIES_VL

Line 41: FROM fnd_currencies_vl fndcvl

37: BEGIN
38:
39: SELECT NVL(fndcvl.precision,0) precision
40: INTO l_curr_precision
41: FROM fnd_currencies_vl fndcvl
42: WHERE fndcvl.currency_code = p_reimb_curr_code;
43:
44: return l_curr_precision;
45:

Line 73: FROM fnd_currencies_vl fndcvl

69: NVL(fndcvl.precision,0) precision,
70: fndcvl.minimum_accountable_unit,
71: fndcvl.derive_factor,
72: fndcvl.derive_effective
73: FROM fnd_currencies_vl fndcvl
74: WHERE fndcvl.enabled_flag = 'Y'
75: AND fndcvl.currency_flag = 'Y'
76: AND trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
77: AND trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)

Line 102: FROM fnd_currencies_vl

98: --------------------------------------------------------------------------------
99: BEGIN
100: SELECT name
101: INTO p_curr_name
102: FROM fnd_currencies_vl
103: WHERE currency_code = p_curr_code;
104:
105: RETURN TRUE;
106: EXCEPTION

Line 131: FROM fnd_currencies_vl fndcvl

127: fndcvl.minimum_accountable_unit
128: INTO p_curr_name,
129: p_precision,
130: p_minimum_acct_unit
131: FROM fnd_currencies_vl fndcvl
132: WHERE currency_code = p_curr_code;
133:
134: return TRUE;
135: EXCEPTION

Line 162: FROM fnd_currencies_vl fndcvl

158: fndcvl.minimum_accountable_unit
159: INTO p_curr_name,
160: p_precision,
161: p_minimum_acct_unit
162: FROM fnd_currencies_vl fndcvl
163: WHERE currency_code = p_curr_code
164: AND fndcvl.enabled_flag = 'Y'
165: AND fndcvl.currency_flag = 'Y'
166: AND trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)

Line 191: FROM fnd_currencies_vl fndcvl

187: --------------------------------------------------------------------------------
188: BEGIN
189: OPEN p_curr_code_cursor FOR
190: SELECT fndcvl.currency_code
191: FROM fnd_currencies_vl fndcvl
192: -- chiho:1326239:
193: WHERE enabled_flag = 'Y'
194: ORDER BY UPPER(fndcvl.currency_code);
195: