DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on GCS_HIERARCHIES_B

Line 114: from gcs_dimension_templates t, gcs_hierarchies_b h

110: t.user_dim7_id,
111: t.user_dim8_id,
112: t.user_dim9_id,
113: t.user_dim10_id
114: from gcs_dimension_templates t, gcs_hierarchies_b h
115: where t.hierarchy_id = h.hierarchy_id
116: and t.template_code = 'SUSPENSE'
117: and h.hierarchy_id = contextData.hierarchy;
118:

Line 1161: FROM GCS_HIERARCHIES_B

1157: -- changes made by yingliu:
1158: /*
1159: cursor getSpecificIntercoId is
1160: SELECT SPECIFIC_INTERCOMPANY_ID
1161: FROM GCS_HIERARCHIES_B
1162: WHERE hierarchy_id = contextData.hierarchy;
1163: */
1164: cursor getSpecificIntercoId is
1165: SELECT SPECIFIC_INTERCOMPANY_ID

Line 2767: FROM GCS_HIERARCHIES_B

2763: -- changes made by yingliu:
2764: /*
2765: cursor getSpecificIntercoId is
2766: SELECT SPECIFIC_INTERCOMPANY_ID
2767: FROM GCS_HIERARCHIES_B
2768: WHERE hierarchy_id = contextData.hierarchy;
2769: */
2770: cursor getSpecificIntercoId is
2771: SELECT SPECIFIC_INTERCOMPANY_ID

Line 5132: FROM gcs_hierarchies_b

5128:
5129: --Bugfix 5456211: Initialize Ledger Id on context data for performance improvements
5130: SELECT fem_ledger_id
5131: INTO contextData.ledgerId
5132: FROM gcs_hierarchies_b
5133: WHERE hierarchy_id = contextData.hierarchy;
5134:
5135: For x in 1 .. runCount Loop
5136: