DBA Data[Home] [Help]

APPS.GCS_AGGREGATION_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 380: FROM GCS_CONS_RELATIONSHIPS gcr,

376: -- get the consolidation type and ownership percent
377: SELECT nvl(min(gt.consolidation_type_code), 'FULL'),
378: min(gcr.ownership_percent)
379: INTO l_consolidation_type, l_ownership_percent
380: FROM GCS_CONS_RELATIONSHIPS gcr,
381: GCS_TREATMENTS_B gt
382: WHERE gcr.cons_relationship_id = p_relationship_id
383: AND gcr.actual_ownership_flag = 'Y'
384: AND gt.treatment_id = gcr.treatment_id;