DBA Data[Home] [Help]

APPS.CSTPSMUT dependencies on FND_CURRENCIES

Line 380: FROM fnd_currencies FC,

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:

Line 1070: FROM fnd_currencies FC,

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:

Line 1867: FROM fnd_currencies FC,

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:

Line 2413: FROM fnd_currencies FC,

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:

Line 3426: FROM fnd_currencies fc,

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: