APPS.PO_CURRENCY_SV dependencies on FND_CURRENCIES

Line 27: FROM fnd_currencies

23: /* Check if the given Currency is active */
24:
25: SELECT currency_code
26: INTO X_currency_code_v
27: FROM fnd_currencies
28: WHERE enabled_flag = 'Y'
29: AND sysdate between nvl(start_date_active, sysdate - 1)
30: AND nvl(end_date_active, sysdate + 1)
31: AND currency_code = X_currency_code;

Line 210: FROM fnd_currencies

206:
207:
208: cursor C is SELECT start_date_active, end_date_active,
209: enabled_flag
210: FROM fnd_currencies
211: WHERE fnd_currencies.currency_code = p_cur_record.currency_code;
212:
213: X_cur_record C%ROWTYPE;
214: X_sysdate DATE := sysdate;

Line 211: WHERE fnd_currencies.currency_code = p_cur_record.currency_code;

207:
208: cursor C is SELECT start_date_active, end_date_active,
209: enabled_flag
210: FROM fnd_currencies
211: WHERE fnd_currencies.currency_code = p_cur_record.currency_code;
212:
213: X_cur_record C%ROWTYPE;
214: X_sysdate DATE := sysdate;
215:

Line 477: l_precision FND_CURRENCIES.precision%TYPE;

473: ---------------------------------------------------------------------------
474: FUNCTION get_currency_precision ( p_currency IN VARCHAR2 )
475: RETURN NUMBER IS
476:
477: l_precision FND_CURRENCIES.precision%TYPE;
478: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
479: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
480:
481: BEGIN

Line 478: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;

474: FUNCTION get_currency_precision ( p_currency IN VARCHAR2 )
475: RETURN NUMBER IS
476:
477: l_precision FND_CURRENCIES.precision%TYPE;
478: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
479: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
480:
481: BEGIN
482: FND_CURRENCY.get_info ( p_currency,

Line 479: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

475: RETURN NUMBER IS
476:
477: l_precision FND_CURRENCIES.precision%TYPE;
478: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
479: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
480:
481: BEGIN
482: FND_CURRENCY.get_info ( p_currency,
483: l_precision,