APPS.GCS_RULES_PROCESSOR dependencies on GCS_RULE_SCOPE_DTLS

Line 1091: -- from gcs_rule_scope_dtls t

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) ;
1093: --
1094: --
1095: -- For the cctr_org and interco dimensions, the target value is always

Line 1400: GCS_RULE_SCOPE_DTLS D' || j;

1396:
1397: END IF; --IF selectDims(i).target_member_id IS NULL THEN
1398:
1399: fromList := fromList || ',
1400: GCS_RULE_SCOPE_DTLS D' || j;
1401:
1402: /*
1403: whereClause := whereClause || '
1404: AND ((b.' || selectDims(i).column_name || ' = D' || j || '.source_member_id

Line 2112: -- from gcs_rule_scope_dtls t

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) ;
2114: --
2115: --
2116: -- For the cctr_org and interco dimensions, the target value is always

Line 2388: gcs_rule_scope_dtls ' || selectDims(i).alias;

2384:
2385: if selectDims(i).all_source_members_flag <> 'Y' then
2386:
2387: fromList := fromList || ' ,
2388: gcs_rule_scope_dtls ' || selectDims(i).alias;
2389: whereClause := whereClause || '
2390: AND ' || selectDims(i)
2391: .alias || '.rule_step_id = :rsi';
2392: bindVarInfo('sourcecolumn' || selectDims(i).alias) := selectDims(i)

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;