APPS.GCS_CONS_MONITOR_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 34: FROM gcs_cons_relationships gcr

30: --
31:
32: CURSOR c_parent_entities(p_end_date DATE, p_hierarchy_id NUMBER, p_entity_id NUMBER) IS
33: SELECT gcr.parent_entity_id
34: FROM gcs_cons_relationships gcr
35: START WITH child_entity_id = p_entity_id
36: AND dominant_parent_flag = 'Y'
37: AND gcr.hierarchy_id = p_hierarchy_id
38: AND p_end_date BETWEEN gcr.start_date AND

Line 56: FROM gcs_cons_relationships gcr,

52: -- Bugfix 5843592, Get the correct entity, depending upon the calendar period
53:
54: CURSOR c_child_count IS
55: SELECT count(1)
56: FROM gcs_cons_relationships gcr,
57: fem_entities_attr fea,
58: gcs_entities_attr gea
59: WHERE gcr.hierarchy_id = p_hierarchy_id
60: AND gcr.parent_entity_id = p_entity_id

Line 81: gcs_cons_relationships gcr,

77: CURSOR c_op_entities IS
78: SELECT status_code
79: FROM gcs_data_sub_dtls gdsd,
80: fem_entities_attr fea,
81: gcs_cons_relationships gcr,
82: gcs_cal_period_maps_gt gcpmt,
83: fem_ledgers_attr fla,
84: gcs_entity_cons_attrs geca,
85: gcs_entities_attr gea

Line 116: gcs_cons_relationships gcr

112: CURSOR c_cons_entities IS
113: SELECT gcds.status_code
114: FROM gcs_cons_data_statuses gcds,
115: fem_entities_attr fea,
116: gcs_cons_relationships gcr
117: WHERE gcr.child_entity_id = gcds.consolidation_entity_id
118: AND gcds.cal_period_id = p_cal_period_id
119: AND gcds.balance_type_code = p_balance_type_code
120: AND gcds.hierarchy_id = p_hierarchy_id

Line 337: FROM gcs_cons_relationships gcr

333: WHERE hierarchy_id = p_hierarchy_id
334: AND status_code in ('COMPLETED', 'WARNING', 'ERROR')
335: AND consolidation_entity_id in
336: (SELECT gcr.parent_entity_id
337: FROM gcs_cons_relationships gcr
338: START WITH child_entity_id = p_entity_id
339: AND hierarchy_id = p_hierarchy_id
340: AND dominant_parent_flag = 'Y'
341: CONNECT BY prior parent_entity_id = child_entity_id

Line 538: FROM gcs_cons_relationships gcr

534: SELECT gcr.child_entity_id,
535: gcr.hierarchy_id,
536: gcr.start_date,
537: gcr.end_date
538: FROM gcs_cons_relationships gcr
539: WHERE cons_relationship_id = p_cons_rel_id;
540:
541: CURSOR c_child_id(p_hierarchy_id NUMBER) IS
542: SELECT gcr.child_entity_id,

Line 544: FROM gcs_cons_relationships gcr,

540:
541: CURSOR c_child_id(p_hierarchy_id NUMBER) IS
542: SELECT gcr.child_entity_id,
543: gcr.start_date
544: FROM gcs_cons_relationships gcr,
545: fem_entities_attr fea
546: WHERE gcr.hierarchy_id = p_hierarchy_id
547: AND gcr.dominant_parent_flag = 'Y'
548: AND gcr.child_entity_id = fea.entity_id

Line 723: FROM gcs_cons_relationships gcr,

719:
720: CURSOR c_child_id IS
721: SELECT gcr.child_entity_id,
722: gcr.start_date
723: FROM gcs_cons_relationships gcr,
724: fem_entities_attr fea
725: WHERE gcr.hierarchy_id = p_hierarchy_id
726: AND gcr.dominant_parent_flag = 'Y'
727: AND gcr.child_entity_id = fea.entity_id