DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on FND_CURRENCIES

Line 168: From fnd_currencies

164: selectDims dimsTable;
165:
166: Cursor getCurrency Is
167: Select nvl(precision, 2), minimum_accountable_unit
168: From fnd_currencies
169: Where currency_code = contextData.currencyCode;
170:
171: --jh 6.29.04: add org/interco output code.
172: --Category info

Line 482: fnd_currencies fc

478: nvl(precision, 2) precision
479: FROM gcs_cons_relationships gcr,
480: fem_entities_attr fea,
481: gcs_entity_cons_attrs geca,
482: fnd_currencies fc
483: WHERE gcr.hierarchy_id = contextData.hierarchy
484: AND gcr.child_entity_id = contextData.childEntity
485: AND gcr.actual_ownership_flag = 'N'
486: AND l_end_date between gcr.start_date and

Line 508: fnd_currencies fc

504: geca.currency_code,
505: nvl(precision, 2) precision
506: FROM gcs_cons_relationships gcr,
507: gcs_entity_cons_attrs geca,
508: fnd_currencies fc
509: WHERE gcr.hierarchy_id = contextData.hierarchy
510: AND gcr.child_entity_id = contextData.childEntity
511: AND gcr.actual_ownership_flag = 'N'
512: AND l_end_date between gcr.start_date and

Line 527: fnd_currencies fc

523: geh.currency_code,
524: nvl(precision, 2) precision
525: FROM gcs_cons_relationships gcr,
526: gcs_entry_headers geh,
527: fnd_currencies fc
528: WHERE gcr.hierarchy_id = contextData.hierarchy
529: AND gcr.child_entity_id = contextData.childEntity
530: AND gcr.actual_ownership_flag = 'N'
531: AND l_end_date between gcr.start_date and

Line 5094: from fnd_currencies

5090:
5091: --Bugfix 4928211: Select precision of currency into contextData
5092: select NVL(minimum_accountable_unit, POWER(10, -precision))
5093: into contextData.currPrecision
5094: from fnd_currencies
5095: where currency_code = contextData.currencyCode;
5096:
5097: --Bugfix 4925150: Do not execute rules processor if formula evaluates to zero for performance savings
5098: if contextData.eventType = 'C' then