APPS.GCS_CONS_MONITOR_PKG dependencies on GCS_DATA_SUB_DTLS

Line 79: FROM gcs_data_sub_dtls gdsd,

75: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period
76:
77: CURSOR c_op_entities IS
78: SELECT status_code
79: FROM gcs_data_sub_dtls gdsd,
80: fem_entities_attr fea,
81: gcs_cons_relationships gcr,
82: gcs_cal_period_maps_gt gcpmt,
83: fem_ledgers_attr fla,

Line 282: FROM gcs_data_sub_dtls gdsd,

278: -- bug fix 4554149
279: CURSOR c_entity_period IS
280: SELECT fcpa.cal_period_id,
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

Line 499: FROM gcs_data_sub_dtls gdsd,

495: gdsd.entity_id,
496: fcpb.cal_period_id,
497: gdsd.balance_type_code,
498: fcpa.date_assign_value
499: FROM gcs_data_sub_dtls gdsd,
500: fem_cal_periods_attr fcpa,
501: gcs_cal_period_maps_gt gcpmt,
502: gcs_hierarchies_b ghb,
503: fem_cal_periods_b fcpb,

Line 584: FROM gcs_data_sub_dtls

580:
581: --Explode into calendar period maps table gcs_cal_period_maps_gt
582: SELECT cal_period_id
583: INTO l_cal_period_id
584: FROM gcs_data_sub_dtls
585: WHERE load_id = l_load_id;
586:
587: gcs_utility_pkg.populate_calendar_map_details(l_cal_period_id,
588: 'Y',