[Home] [Help]
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
287: WHERE gdsd.entity_id = p_entity_id
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;
313:
342: AND hierarchy_id = p_hierarchy_id
343: AND dominant_parent_flag = 'Y')
344: AND EXISTS
345: (SELECT 1
346: FROM fem_cal_periods_attr fcpa
347: WHERE fcpa.cal_period_id = gcds.cal_period_id
348: AND fcpa.attribute_id = g_cal_period_end_date_attr
349: AND fcpa.version_id = g_cal_period_end_date_version
350: AND fcpa.date_assign_value >= p_start_date);
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,
504: fem_ledgers_attr fla,
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
510: AND fcpb.cal_period_id = gcpmt.target_cal_period_id
511: AND fcpb.calendar_id = ghb.calendar_id
554: SELECT gcds.cal_period_id,
555: gcds.balance_type_code,
556: fcpa.date_assign_value
557: FROM gcs_cons_data_statuses gcds,
558: fem_cal_periods_attr fcpa
559: WHERE hierarchy_id = p_hierarchy_id
560: AND consolidation_entity_id = p_entity_id
561: AND gcds.cal_period_id = fcpa.cal_period_id
562: AND fcpa.attribute_id = g_cal_period_end_date_attr