[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT eca.currency_code
INTO l_ccy_code
FROM gcs_entity_cons_attrs eca
WHERE eca.hierarchy_id = p_hierarchy_id
AND eca.entity_id = p_entity_id;
SELECT fea.dim_attribute_numeric_member
INTO l_ledger_id
FROM fem_entities_attr fea
WHERE fea.entity_id = p_entity_id
AND fea.attribute_id = g_entity_ledger_attr_id
AND fea.version_id = g_entity_ledger_v_id;
SELECT gea.ledger_id
INTO l_ledger_id
FROM gcs_entities_attr gea,
fem_cal_periods_attr fcpa_end_date
WHERE gea.entity_id = p_entity_id
AND gea.data_type_code = 'ACTUAL'
AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)
AND fcpa_end_date.attribute_id = g_cp_enddate_attr_id
AND fcpa_end_date.version_id = g_cp_enddate_v_id
AND fcpa_end_date.date_assign_value
BETWEEN gea.effective_start_date
AND nvl(gea.effective_end_date, fcpa_end_date.date_assign_value);
SELECT fea.dim_attribute_numeric_member
INTO l_src_sys_code
FROM fem_entities_attr fea
WHERE fea.entity_id = p_entity_id
AND fea.attribute_id = g_entity_srcsys_attr_id
AND fea.version_id = g_entity_srcsys_v_id;
SELECT gea.source_system_code
INTO l_src_sys_code
FROM gcs_entities_attr gea,
fem_cal_periods_attr fcpa_end_date
WHERE gea.entity_id = p_entity_id
AND gea.data_type_code = 'ACTUAL'
AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)
AND fcpa_end_date.attribute_id = g_cp_enddate_attr_id
AND fcpa_end_date.version_id = g_cp_enddate_v_id
AND fcpa_end_date.date_assign_value
BETWEEN gea.effective_start_date
AND nvl(gea.effective_end_date, fcpa_end_date.date_assign_value);
SELECT fdl.dataset_code
INTO l_dataset_code
FROM fem_data_locations fdl
WHERE fdl.ledger_id = l_ledger_id
AND fdl.cal_period_id = to_number(p_pristine_cal_period_id_str)
AND fdl.source_system_code = l_src_sys_code
AND fdl.table_name = 'FEM_BALANCES'
AND fdl.balance_type_code = 'ACTUAL';
SELECT 1
FROM gcs_data_sub_dtls gdsd
WHERE gdsd.entity_id = p_entity_id
AND gdsd.cal_period_id = to_number(p_fch_cal_period_id_str);
SELECT fcpb_source.cal_period_id source_cal_period_id
FROM fem_cal_periods_b fcpb_source,
fem_cal_periods_b fcpb_target,
gcs_cal_period_maps gcpm,
fem_cal_periods_attr fcpb_source_num,
fem_cal_periods_attr fcpb_source_year,
fem_cal_periods_attr fcpb_target_num,
fem_cal_periods_attr fcpb_target_year,
gcs_cal_period_map_dtls gcpmd
WHERE fcpb_target.cal_period_id = to_number(p_fch_cal_period_id_str)
AND fcpb_target.calendar_id = gcpm.target_calendar_id
AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id
AND fcpb_target_num.cal_period_id = to_number(p_fch_cal_period_id_str)
AND fcpb_target_year.cal_period_id = to_number(p_fch_cal_period_id_str)
AND fcpb_target_num.attribute_id = g_cp_num_attr_id
AND fcpb_target_num.version_id = g_cp_num_v_id
AND fcpb_target_year.attribute_id = g_cp_year_attr_id
AND fcpb_target_year.version_id = g_cp_year_v_id
AND gcpm.cal_period_map_id = gcpmd.cal_period_map_id
AND gcpmd.target_period_number = fcpb_target_num.number_assign_value
AND fcpb_source_num.attribute_id = g_cp_num_attr_id
AND fcpb_source_num.version_id = g_cp_num_v_id
AND fcpb_source_year.attribute_id = g_cp_year_attr_id
AND fcpb_source_year.version_id = g_cp_year_v_id
AND fcpb_source.cal_period_id = fcpb_source_num.cal_period_id
AND fcpb_source.cal_period_id = fcpb_source_year.cal_period_id
AND fcpb_source.calendar_id = gcpm.source_calendar_id
AND fcpb_source.dimension_group_id = gcpm.source_dimension_group_id
AND fcpb_source_num.number_assign_value = gcpmd.source_period_number
AND fcpb_source_year.number_assign_value =
DECODE(gcpmd.target_relative_year_code,
'CURRENT', fcpb_target_year.number_assign_value,
'PRIOR', fcpb_target_year.number_assign_value + 1,
'FOLLOWING', fcpb_target_year.number_assign_value - 1)
AND fcpb_source.cal_period_id IN
(SELECT gdsd.cal_period_id
FROM gcs_data_sub_dtls gdsd
WHERE gdsd.entity_id = p_entity_id)
ORDER BY fcpb_source_year.number_assign_value desc,
fcpb_source_num.number_assign_value desc;