eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GCS_RAISE_EVENT_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 101: FROM gcs_cons_relationships gcr

97: AND gcer.hierarchy_id = p_consolidation_hierarchy
98: AND gcer.cal_period_id = p_cal_period_id
99: AND gcer.balance_type_code = p_balance_type_code
100: AND EXISTS (SELECT 'X'
101: FROM gcs_cons_relationships gcr
102: WHERE gcr.child_entity_id = gcer.run_entity_id
103: START WITH gcr.parent_entity_id = p_consolidation_entity
104: AND gcr.hierarchy_id = p_consolidation_hierarchy
105: AND TO_DATE(l_cal_period_end_date, 'DD-MM-RR')

Line 205: FROM gcs_cons_relationships gcr

201: AND gcer.hierarchy_id = p_consolidation_hierarchy
202: AND gcer.cal_period_id = p_cal_period_id
203: AND gcer.balance_type_code = p_balance_type_code
204: AND EXISTS (SELECT 'X'
205: FROM gcs_cons_relationships gcr
206: WHERE gcr.child_entity_id = gcer.run_entity_id
207: START WITH gcr.parent_entity_id = p_consolidation_entity
208: AND gcr.hierarchy_id = p_consolidation_hierarchy
209: AND TO_DATE(l_cal_period_end_date, 'DD-MM-RR')

Line 426: FROM gcs_cons_relationships gcr

422: AND gcer.hierarchy_id = p_consolidation_hierarchy
423: AND gcer.cal_period_id = p_cal_period_id
424: AND gcer.balance_type_code = p_balance_type_code
425: AND EXISTS (SELECT 'X'
426: FROM gcs_cons_relationships gcr
427: WHERE gcr.child_entity_id = gcer.run_entity_id
428: START WITH gcr.parent_entity_id = p_consolidation_entity
429: AND gcr.hierarchy_id = p_consolidation_hierarchy
430: AND TO_DATE(l_cal_period_end_date, 'DD-MM-RR')

Line 488: FROM gcs_cons_relationships gcr,

484: fnd_global.user_id,
485: fnd_global.login_id,
486: 1,
487: gtb.consolidation_type_code
488: FROM gcs_cons_relationships gcr,
489: --Bugfix 5091093: Added join for consolidation type code
490: gcs_treatments_b gtb
491: WHERE gtb.treatment_id(+) = gcr.treatment_id
492: START WITH gcr.parent_entity_id = p_consolidation_entity

Line 550: FROM gcs_cons_relationships gcr

546: AND gcer.hierarchy_id = p_consolidation_hierarchy
547: AND gcer.cal_period_id = p_cal_period_id
548: AND gcer.balance_type_code = p_balance_type_code
549: AND EXISTS (SELECT 'X'
550: FROM gcs_cons_relationships gcr
551: WHERE gcr.child_entity_id = gcer.run_entity_id
552: START WITH gcr.parent_entity_id = p_consolidation_entity
553: AND gcr.hierarchy_id = p_consolidation_hierarchy
554: AND TO_DATE(l_cal_period_end_date, 'DD-MM-RR')