DBA Data[Home] [Help]

APPS.CSTPAPPR dependencies on FND_CURRENCIES

Line 1433: FROM fnd_currencies c2

1429: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1430: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1431: * c2.minimum_accountable_unit )
1432: INTO l_ae_line_rec.transaction_value
1433: FROM fnd_currencies c2
1434: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1435: l_curr_rec.pri_currency,
1436: l_curr_rec.alt_currency);
1437:

Line 1495: FROM fnd_currencies c2

1491: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1492: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1493: * c2.minimum_accountable_unit )
1494: INTO l_ae_line_rec.transaction_value
1495: FROM fnd_currencies c2
1496: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1497: l_curr_rec.pri_currency,
1498: l_curr_rec.alt_currency);
1499:

Line 1548: FROM fnd_currencies c2

1544: NULL,round(l_ae_line_rec.transaction_value,c2.precision),
1545: round(l_ae_line_rec.transaction_value/c2.minimum_accountable_unit)
1546: * c2.minimum_accountable_unit )
1547: INTO l_ae_line_rec.transaction_value
1548: FROM fnd_currencies c2
1549: WHERE c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
1550: l_curr_rec.pri_currency,
1551: l_curr_rec.alt_currency);
1552:

Line 3123: fnd_currencies c1,

3119: l_current_accounted_value,
3120: l_prior_entered_value,
3121: l_prior_accounted_value
3122: from
3123: fnd_currencies c1,
3124: fnd_currencies c2
3125: where
3126: c1.currency_code = l_curr_rec.pri_currency
3127: and c2.currency_code = decode(l_curr_rec.alt_currency, NULL,

Line 3124: fnd_currencies c2

3120: l_prior_entered_value,
3121: l_prior_accounted_value
3122: from
3123: fnd_currencies c1,
3124: fnd_currencies c2
3125: where
3126: c1.currency_code = l_curr_rec.pri_currency
3127: and c2.currency_code = decode(l_curr_rec.alt_currency, NULL,
3128: l_curr_rec.pri_currency,

Line 4002: fnd_currencies c1,

3998: into
3999: l_entered_value,
4000: l_accounted_value
4001: from
4002: fnd_currencies c1,
4003: fnd_currencies c2
4004: where
4005: c1.currency_code = i_ae_curr_rec.pri_currency
4006: and c2.currency_code = decode(i_ae_curr_rec.alt_currency, NULL,

Line 4003: fnd_currencies c2

3999: l_entered_value,
4000: l_accounted_value
4001: from
4002: fnd_currencies c1,
4003: fnd_currencies c2
4004: where
4005: c1.currency_code = i_ae_curr_rec.pri_currency
4006: and c2.currency_code = decode(i_ae_curr_rec.alt_currency, NULL,
4007: i_ae_curr_rec.pri_currency,