[Home] [Help]
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,
84: gcs_entity_cons_attrs geca,
85: gcs_entities_attr gea
86: WHERE gcr.child_entity_id = gdsd.entity_id
304:
305: cursor c_target_cal_period is
306: select target_cal_period_id,
307: fcpa.date_assign_value
308: from gcs_cal_period_maps_gt gcpmt,
309: fem_cal_periods_attr fcpa
310: where gcpmt.target_cal_period_id = fcpa.cal_period_id
311: and fcpa.attribute_id = g_cal_period_end_date_attr
312: and fcpa.version_id = g_cal_period_end_date_version;
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,
504: fem_ledgers_attr fla,
505: gcs_entity_cons_attrs geca,
577: -- event raised from data submission
578: -- loop through each parent of the newly loaded entity and scan its children's status
579: IF (l_load_id IS NOT NULL) THEN
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;