DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on FND_CURRENCIES

Line 1320: FROM fnd_currencies fc_1, fnd_currencies fc_stat

1316: ' SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),
1317: NVL (fc_stat.minimum_accountable_unit, POWER (10, -fc_stat.PRECISION))
1318: INTO l_precision,
1319: l_stat_precision
1320: FROM fnd_currencies fc_1, fnd_currencies fc_stat
1321: WHERE fc_1.currency_code = ' ||p_source_currency_code||'
1322: AND fc_stat.currency_code = ''STAT''');
1323: END IF;
1324: SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),

Line 1327: FROM fnd_currencies fc_1, fnd_currencies fc_stat

1323: END IF;
1324: SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),
1325: NVL (fc_stat.minimum_accountable_unit, POWER (10, -fc_stat.PRECISION))
1326: INTO l_precision, l_stat_precision
1327: FROM fnd_currencies fc_1, fnd_currencies fc_stat
1328: WHERE fc_1.currency_code = p_source_currency_code
1329: AND fc_stat.currency_code = 'STAT';
1330: INSERT INTO gcs_entry_lines
1331: (entry_id,

Line 1931: FROM fnd_currencies fc_1, fnd_currencies fc_stat

1927: THEN
1928: SELECT NVL (fc_1.minimum_accountable_unit, POWER (10, -fc_1.PRECISION)),
1929: NVL (fc_stat.minimum_accountable_unit, POWER (10, -fc_stat.PRECISION))
1930: INTO l_precision, l_stat_precision
1931: FROM fnd_currencies fc_1, fnd_currencies fc_stat
1932: WHERE fc_1.currency_code = p_source_currency_code
1933: AND fc_stat.currency_code = 'STAT';
1934: INSERT INTO gcs_entry_lines
1935: (entry_id,