DBA Data[Home] [Help]

APPS.GCS_CONS_MONITOR_PKG dependencies on GCS_ENTITY_CONS_ATTRS

Line 84: gcs_entity_cons_attrs geca,

80: fem_entities_attr fea,
81: gcs_cons_relationships gcr,
82: gcs_cal_period_maps_gt gcpmt,
83: fem_ledgers_attr fla,
84: gcs_entity_cons_attrs geca,
85: gcs_entities_attr gea
86: WHERE gcr.child_entity_id = gdsd.entity_id
87: AND p_cal_period_id = gcpmt.target_cal_period_id
88: AND gdsd.cal_period_id = gcpmt.source_cal_period_id

Line 285: gcs_entity_cons_attrs geca,

281: gdsd.balance_type_code
282: FROM gcs_data_sub_dtls gdsd,
283: fem_cal_periods_attr fcpa,
284: fem_ledgers_attr fla,
285: gcs_entity_cons_attrs geca,
286: fem_entities_attr fea_cur
287: WHERE gdsd.entity_id = p_entity_id
288: AND gdsd.cal_period_id = fcpa.cal_period_id
289: AND gdsd.most_recent_flag = 'Y'

Line 505: gcs_entity_cons_attrs geca,

501: gcs_cal_period_maps_gt gcpmt,
502: gcs_hierarchies_b ghb,
503: fem_cal_periods_b fcpb,
504: fem_ledgers_attr fla,
505: gcs_entity_cons_attrs geca,
506: gcs_entities_attr gea,
507: fem_cal_periods_attr fcpa_curr
508: WHERE gdsd.cal_period_id = gcpmt.source_cal_period_id
509: AND fcpb.cal_period_id = fcpa.cal_period_id