[Home] [Help]
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 || '
967: 'TRANSLATED')
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