APPS.GCS_CONS_ENG_UTILITY_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 731: gcs_cons_relationships gcr

727: 'WARNING',
728: 'COMPLETED') request_status
729: FROM gcs_entry_headers geh,
730: gcs_ad_transactions gad,
731: gcs_cons_relationships gcr
732: WHERE geh.entry_id = gad.assoc_entry_id
733: AND gcr.cons_relationship_id = NVL(gad.post_cons_relationship_id, gad.pre_cons_relationship_id)
734: AND geh.category_code = 'ACQ_DISP'
735: AND geh.hierarchy_id = p_hierarchy_id

Line 1172: FROM gcs_cons_relationships gcr,

1168: -1 elimination_entity_id,
1169: geca.currency_code,
1170: gcr.ownership_percent / 100 ownership_percent,
1171: gcatb.target_entity_code
1172: FROM gcs_cons_relationships gcr,
1173: gcs_entity_cons_attrs geca,
1174: gcs_elim_rule_rels gerr,
1175: gcs_dataset_codes gdc,
1176: gcs_elim_rules_b grb,

Line 1208: FROM gcs_cons_relationships gcr,

1204: fea.dim_attribute_numeric_member elimination_entity_id,
1205: geca.currency_code,
1206: gcr.ownership_percent / 100 ownership_percent,
1207: gcatb.target_entity_code
1208: FROM gcs_cons_relationships gcr,
1209: gcs_entity_cons_attrs geca,
1210: gcs_elim_rule_rels gerr,
1211: gcs_dataset_codes gdc,
1212: fem_entities_attr fea,

Line 1597: FROM gcs_cons_relationships

1593: AND ROWNUM < 2;
1594:
1595: SELECT cons_relationship_id
1596: INTO l_parameter_list.cons_relationship_id
1597: FROM gcs_cons_relationships
1598: WHERE hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1599: AND dominant_parent_flag = 'Y'
1600: AND child_entity_id = l_entity_id
1601: AND cons_entity_wf_info.cal_period_end_date BETWEEN start_date AND NVL(end_date, cons_entity_wf_info.cal_period_end_date);