APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_ENTITY_CONS_ATTRS

Line 794: gcs_entity_cons_attrs geca,

790: gcr.cons_relationship_id
791: FROM gcs_cons_eng_runs gcer,
792: gcs_cons_relationships gcr,
793: fem_cal_periods_attr fcpa,
794: gcs_entity_cons_attrs geca,
795: gcs_cal_period_maps_gt gcpmt,
796: fem_cal_periods_b fcpb,
797: gcs_hierarchies_b ghb
798: WHERE gcer.most_recent_flag = 'Y'

Line 1310: gcs_entity_cons_attrs geca_parent,

1306: gcs_curr_treatments_b gctb,
1307: fem_cal_periods_b fcpb,
1308: fem_cal_periods_attr fcpa_end,
1309: gcs_cons_relationships gcr,
1310: gcs_entity_cons_attrs geca_parent,
1311: gcs_entity_cons_attrs geca_child
1312: WHERE gcer.cal_period_id = fcpb.cal_period_id
1313: AND fcpb.cal_period_id = fcpa_end.cal_period_id
1314: AND fcpa_end.attribute_id = l_cp_end_date_attr_id

Line 1311: gcs_entity_cons_attrs geca_child

1307: fem_cal_periods_b fcpb,
1308: fem_cal_periods_attr fcpa_end,
1309: gcs_cons_relationships gcr,
1310: gcs_entity_cons_attrs geca_parent,
1311: gcs_entity_cons_attrs geca_child
1312: WHERE gcer.cal_period_id = fcpb.cal_period_id
1313: AND fcpb.cal_period_id = fcpa_end.cal_period_id
1314: AND fcpa_end.attribute_id = l_cp_end_date_attr_id
1315: AND fcpa_end.version_id = l_cp_end_date_version_id