376: SELECT NVL(FC.minimum_accountable_unit, POWER(10,NVL(-precision,0))),
377: NVL(FC.extended_precision,NVL(FC.precision,0))
378: INTO l_min_acct_unit,
379: l_ext_prec
380: FROM fnd_currencies FC,
381: CST_ORGANIZATION_DEFINITIONS O
382: WHERE O.organization_id = l_organization_id
383: AND O.currency_code = FC.currency_code;
384:
1066: SELECT NVL(FC.minimum_accountable_unit, POWER(10,NVL(-precision,0))),
1067: NVL(FC.extended_precision,NVL(FC.precision,0))
1068: INTO l_min_acct_unit,
1069: l_ext_prec
1070: FROM fnd_currencies FC,
1071: CST_ORGANIZATION_DEFINITIONS O
1072: WHERE O.organization_id = l_organization_id
1073: AND O.currency_code = FC.currency_code;
1074:
1863: SELECT NVL(FC.minimum_accountable_unit, POWER(10,NVL(-precision,0))),
1864: NVL(FC.extended_precision,NVL(FC.precision,0))
1865: INTO l_min_acct_unit,
1866: l_ext_prec
1867: FROM fnd_currencies FC,
1868: CST_ORGANIZATION_DEFINITIONS O
1869: WHERE O.organization_id = l_organization_id
1870: AND O.currency_code = FC.currency_code;
1871:
2409: SELECT NVL(FC.minimum_accountable_unit, POWER(10,NVL(-precision,0))),
2410: NVL(FC.extended_precision,NVL(FC.precision,0))
2411: INTO l_min_acct_unit,
2412: l_ext_prec
2413: FROM fnd_currencies FC,
2414: CST_ORGANIZATION_DEFINITIONS O
2415: WHERE O.organization_id = l_organization_id
2416: AND O.currency_code = FC.currency_code;
2417:
3422: /* Get Minimum Accounting Unit */
3423:
3424: SELECT NVL(FC.minimum_accountable_unit, POWER(10,NVL(-precision,0)))
3425: INTO l_min_acct_unit
3426: FROM fnd_currencies fc,
3427: cst_organization_definitions o
3428: WHERE o.organization_id = l_org_id
3429: AND o.currency_code = fc.currency_code;
3430: