[Home] [Help]
214: 'INSERT INTO gcs_cal_period_maps_gt (source_cal_period_id, target_cal_period_id)
215: SELECT fdl.cal_period_id, ' ||
216: p_target_cal_period_id || '
217: FROM fem_data_locations fdl, ' || '
218: fem_ledgers_attr fla, ' || '
219: fem_cal_periods_attr fcpa_number, ' || '
220: fem_cal_periods_attr fcpa_year, ' || '
221: gcs_cal_period_map_dtls gcpmd, ' || '
222: gcs_cal_period_maps gcpm, ' || '
274: INSERT INTO gcs_cal_period_maps_gt
275: (source_cal_period_id, target_cal_period_id)
276: SELECT fdl.cal_period_id, p_target_cal_period_id
277: FROM fem_data_locations fdl,
278: fem_ledgers_attr fla,
279: fem_cal_periods_attr fcpa_number,
280: fem_cal_periods_attr fcpa_year,
281: gcs_cal_period_map_dtls gcpmd,
282: gcs_cal_period_maps gcpm,
931: )
932: INTO l_source_ledger_id,
933: l_source_currency_code,
934: l_source_currency_type_code
935: FROM gcs_entity_cons_attrs geca, fem_ledgers_attr fla, gcs_entities_attr gea
936: WHERE geca.entity_id = ' ||
937: p_entity_id || '
938: AND geca.hierarchy_id = ' ||
939: p_hierarchy_id || '
968: INTO l_source_ledger_id,
969: l_source_currency_code,
970: l_source_currency_type_code
971: FROM gcs_entity_cons_attrs geca,
972: fem_ledgers_attr fla,
973: gcs_entities_attr gea,
974: fem_cal_periods_attr fcpa
975: WHERE geca.entity_id = p_entity_id
976: AND geca.hierarchy_id = p_hierarchy_id
1308: FROM fem_balances fb,
1309: gcs_entity_cctr_orgs geco ';
1310: l_inc_from_clause := '
1311: FROM fem_balances fb,
1312: fem_ledgers_attr fla,
1313: gcs_entity_cctr_orgs geco,
1314: gcs_cons_impact_analyses gcia,
1315: gcs_data_sub_dtls gdsd ';
1316: l_where_gt_clause := '
1411: fnd_log.STRING (fnd_log.level_statement,
1412: g_pkg_name || ''.'' || l_api_name,
1413: '' SELECT fla.dim_attribute_numeric_member
1414: INTO l_source_global_vs_combo
1415: FROM fem_ledgers_attr fla,
1416: fem_dim_attributes_b fdab,
1417: fem_dim_attr_versions_b fdavb
1418: WHERE fla.ledger_id = '' || p_source_ledger_id || ''
1419: AND fla.attribute_id = fdab.attribute_id
1423: AND fdavb.default_version_flag = ''''Y'''' '');
1424: END IF;
1425: SELECT fla.dim_attribute_numeric_member
1426: INTO l_source_global_vs_combo
1427: FROM fem_ledgers_attr fla,
1428: fem_dim_attributes_b fdab,
1429: fem_dim_attr_versions_b fdavb
1430: WHERE fla.ledger_id = p_source_ledger_id
1431: AND fla.attribute_id = fdab.attribute_id