APPS.GCS_RULES_PROCESSOR dependencies on GCS_RULE_SCOPE_DIMS

Line 76: FROM GCS_RULE_SCOPE_DIMS d

72:
73: --3702208: Get target-only DMS info from _DIMS table
74: Cursor getTgtDims(rsi number) is
75: SELECT d.column_name, d.target_member_id
76: FROM GCS_RULE_SCOPE_DIMS d
77: WHERE d.rule_step_id = rsi;
78:
79: TYPE tgtDimsTable IS TABLE OF getTgtDims%ROWTYPE INDEX BY VARCHAR2(30);
80: tgtDims tgtDimsTable;

Line 155: GCS_RULE_SCOPE_DIMS s,

151: s.hierarchy_obj_id,
152: x.hierarchy_table_name,
153: initcap(replace(replace(s.column_name, '_', ''), 'ID', '')) alias
154: FROM FEM_XDIM_DIMENSIONS x,
155: GCS_RULE_SCOPE_DIMS s,
156: FEM_TAB_COLUMNS_B ftcb
157: WHERE ftcb.table_name = 'FEM_BALANCES'
158: AND ftcb.column_name = s.column_name
159: AND ftcb.dimension_id = x.dimension_id

Line 1088: -- gcs_rule_scope_dims d

1084: -- 0, 0,
1085: -- ,
1086: --
1087: -- FROM fem_balances b,
1088: -- gcs_rule_scope_dims d
1089: -- WHERE b.source_dimension_columns =
1090: -- (select t.source_member_id
1091: -- from gcs_rule_scope_dtls t
1092: -- where t.rule_step_id = :rsi) ;

Line 2109: -- gcs_rule_scope_dims d

2105: -- 0, 0,
2106: -- ,
2107: --
2108: -- FROM fem_balances b,
2109: -- gcs_rule_scope_dims d
2110: -- WHERE b.source_dimension_columns =
2111: -- (select t.source_member_id
2112: -- from gcs_rule_scope_dtls t
2113: -- where t.rule_step_id = :rsi) ;

Line 2739: -- FROM gcs_rule_scope_dims d

2735: -- rule_id, step_seq, formula_text,
2736: -- input_amount, output_amount, )
2737: -- SELECT :rid, :seq, :ftx,
2738: -- 0, 0,
2739: -- FROM gcs_rule_scope_dims d
2740: -- WHERE d.rule_step_id = :rsi;
2741: --
2742: -- The target expressions are actually the l.tgt_ column names.
2743: --

Line 2904: -- Join target-only DMS info to GCS_RULE_SCOPE_DIMS

2900: --=======================================================
2901: logString(eventLogLevel, procedureName, 'section', '5');
2902: --=======================================================
2903:
2904: -- Join target-only DMS info to GCS_RULE_SCOPE_DIMS
2905: -- Add the FROM and WHERE clauses
2906: entriesStmt := entriesStmt || '
2907: FROM gcs_dimension_set_dims d
2908: WHERE g.rule_step_id = :rsi';

Line 3520: FROM GCS_RULE_SCOPE_DTLS T, GCS_RULE_SCOPE_DIMS D

3516: categoryInfo getCategory%ROWTYPE;
3517:
3518: cursor isTgtOnly(rsi number) is
3519: SELECT 1
3520: FROM GCS_RULE_SCOPE_DTLS T, GCS_RULE_SCOPE_DIMS D
3521: WHERE D.ALL_SOURCE_MEMBERS_FLAG = 'N'
3522: AND D.TARGET_MEMBER_ID IS NOT NULL
3523: AND D.RULE_STEP_ID = T.RULE_STEP_ID
3524: AND D.RULE_STEP_ID = rsi;

Line 4585: from gcs_rule_scope_dims grsd, gcs_elim_rule_steps_b grsb

4581: 'Inserting into gcs_entry_lines');
4582:
4583: select decode(count(1), 0, 'N', 'Y')
4584: into offsetFlag
4585: from gcs_rule_scope_dims grsd, gcs_elim_rule_steps_b grsb
4586: where grsd.column_name = 'LINE_ITEM_ID'
4587: and grsd.offset_member_id is not null
4588: and grsb.rule_step_id = grsd.rule_step_id
4589: and grsb.rule_id = ruleId;