APPS.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_HIERARCHIES_B

Line 74: FROM gcs_hierarchies_b

70:
71: -- Get information of the hierarchy
72: SELECT balance_by_org_flag
73: INTO l_bal_by_org_flag
74: FROM gcs_hierarchies_b
75: WHERE hierarchy_id = p_hierarchy_id;
76:
77: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 107: GCS_HIERARCHIES_B ghb,

103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,
109: GCS_CONS_RELATIONSHIPS gcr,
110: GCS_TREATMENTS_B gt
111: WHERE

Line 201: GCS_HIERARCHIES_B ghb,

197: sum(xtd_balance_e), sum(ytd_balance_e),
198: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
199: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e)
200: FROM
201: GCS_HIERARCHIES_B ghb,
202: FEM_BALANCES fb,
203: GCS_CONS_RELATIONSHIPS gcr,
204: GCS_TREATMENTS_B gt
205: WHERE ghb.hierarchy_id = p_hierarchy_id