APPS.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 56: FROM gcs_cons_relationships

52:
53: CURSOR get_child_info IS
54: SELECT child_entity_id,
55: gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id
56: FROM gcs_cons_relationships
57: WHERE hierarchy_id = p_hierarchy_id
58: AND parent_entity_id = p_cons_entity_id
59: AND actual_ownership_flag = 'Y';
60:

Line 109: GCS_CONS_RELATIONSHIPS gcr,

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
112: ghb.hierarchy_id = p_hierarchy_id
113: AND gcr.hierarchy_id = ghb.hierarchy_id

Line 203: GCS_CONS_RELATIONSHIPS gcr,

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
206: AND gcr.hierarchy_id = p_hierarchy_id
207: AND gcr.parent_entity_id = p_cons_entity_id

Line 250: FROM gcs_cons_relationships cr2,

246: line_item_id, company_cost_center_org_id) IN (
247: SELECT
248: line_item_id,
249: retrieve_org_id (cr2.child_entity_id)
250: FROM gcs_cons_relationships cr2,
251: gcs_curr_treatments_b gctb
252: WHERE cr2.parent_entity_id = p_cons_entity_id
253: AND cr2.hierarchy_id = p_hierarchy_id
254: AND cr2.actual_ownership_flag = 'Y'

Line 261: FROM gcs_cons_relationships gcr

257: p_period_end_date
258: )
259: AND gctb.curr_treatment_id IN (
260: SELECT gcr.curr_treatment_id
261: FROM gcs_cons_relationships gcr
262: START WITH gcr.hierarchy_id = p_hierarchy_id
263: AND gcr.parent_entity_id =
264: p_cons_entity_id
265: AND gcr.actual_ownership_flag = 'Y'