APPS.GCS_INTERCO_PROCESSING_PKG dependencies on FND_CURRENCIES

Line 1186: FND_CURRENCIES fc

1182: GCS_FLATTENED_RELNS gfr,
1183: GCS_FLATTENED_RELNS gfr1,
1184: GCS_INTERCO_MEMBERS gim,
1185: GCS_INTERCO_RULES_B gib ,
1186: FND_CURRENCIES fc
1187: WHERE giet.hierarchy_id = p_hierarchy_id
1188: AND giet.cal_period_id = p_cal_period_id
1189: AND fc.currency_code IN (p_currency_code,'STAT')
1190: AND gfr.run_name = g_consolidation_run_name

Line 1319: FND_CURRENCIES fc

1315: GCS_FLATTENED_RELNS gfr,
1316: GCS_FLATTENED_RELNS gfr1,
1317: GCS_INTERCO_MEMBERS gim,
1318: GCS_INTERCO_RULES_B gib ,
1319: FND_CURRENCIES fc
1320: WHERE giet.hierarchy_id = p_hierarchy_id
1321: AND giet.cal_period_id = p_cal_period_id
1322: AND fc.currency_code IN (p_currency_code,'STAT')
1323: AND gfr.run_name = g_consolidation_run_name

Line 1480: FND_CURRENCIES fc

1476: gib.sus_user_dim10_id, fc.currency_code
1477: FROM GCS_INTERCO_ELM_TRX giet,
1478: GCS_INTERCO_MEMBERS gim,
1479: GCS_INTERCO_RULES_B gib,
1480: FND_CURRENCIES fc
1481: WHERE giet.hierarchy_id = p_hierarchy_id
1482: AND giet.cal_period_id = p_cal_period_id
1483: AND fc.currency_code IN (P_currency_code, 'STAT')
1484: AND giet.src_entity_id = p_entity_id

Line 1780: fnd_currencies fnc

1776: SELECT gihg.entry_id, gihg.threshold_currency,
1777: nvl(minimum_accountable_unit, power(10, -precision)) mau,
1778: NVL(precision,2) pres
1779: FROM GCS_INTERCO_HDR_GT gihg, GCS_ENTRY_LINES gel,
1780: fnd_currencies fnc
1781: WHERE gihg.entry_id = gel.entry_id
1782: AND gihg.currency_code <> 'STAT'
1783: AND gihg.threshold_currency <> p_currency_code
1784: AND gihg.currency_code = fnc.currency_code

Line 1797: FROM fnd_currencies

1793:
1794: /* CURSOR ccy_mau_c(c_ccy VARCHAR2) IS
1795: SELECT nvl(minimum_accountable_unit, power(10, -precision)) mau,
1796: NVL(precision,2) pres
1797: FROM fnd_currencies
1798: WHERE currency_code = c_ccy;
1799: */
1800: BEGIN
1801: