[Home] [Help]
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;