APPS.JA_CN_CFS_CALCULATE_PKG dependencies on FND_CURRENCIES

Line 1225: l_precision fnd_currencies.precision%TYPE;

1221: l_amount_per_period NUMBER;
1222: l_amount NUMBER;
1223: l_period_count NUMBER;
1224: l_period_name VARCHAR2(15);
1225: l_precision fnd_currencies.precision%TYPE;
1226: l_balancing_segment_value VARCHAR2(25) := p_balancing_segment_value; --added for CNAO Enhancement
1227: --l_internal_trx_flag VARCHAR2(1) :=p_internal_trx_flag;
1228:
1229: CURSOR c_precision

Line 1234: fnd_currencies

1230: IS
1231: SELECT
1232: nvl(PRECISION,0)
1233: FROM
1234: fnd_currencies
1235: WHERE currency_code=(SELECT
1236: currency_code
1237: FROM
1238: gl_ledgers

Line 1469: l_precision fnd_currencies.precision%TYPE;

1465: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1466: l_axis_seq rg_report_axes.axis_seq%TYPE;
1467: l_amount NUMBER;
1468: l_lastyear_amount NUMBER;
1469: l_precision fnd_currencies.precision%TYPE;
1470: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;
1471: l_segment_override VARCHAR2(100) := p_segment_override; --added for CNAO Enhancement
1472: l_balancing_segment_value JA_CN_CFS_ACTIVITIES_ALL.BALANCING_SEGMENT%TYPE; --added for CNAO Enhancement
1473: --l_internal_trx_flag VARCHAR2(1);

Line 1484: fnd_currencies

1480: IS
1481: SELECT
1482: nvl(PRECISION,0)
1483: FROM
1484: fnd_currencies
1485: WHERE currency_code=(SELECT
1486: currency_code
1487: FROM
1488: gl_ledgers

Line 1795: l_func_currency_code fnd_currencies.currency_code%TYPE;

1791: l_format_mask VARCHAR2(100);
1792: l_final_display_format VARCHAR2(30);
1793: l_legal_entity_id NUMBER :=p_legal_entity_id;
1794: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1795: l_func_currency_code fnd_currencies.currency_code%TYPE;
1796: l_period_name gl_periods.period_name%TYPE :=p_period_name;
1797: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1798: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1799: l_balance_type VARCHAR2(50) :=p_balance_type ;