Hälferliy für Länder
Es Hälferli, um es Hauptland z'ermittle
CREATE OR REPLACE PACKAGE BODY K.RBSC$CURRY_COUNTRY IS
-------------------------------------------------------------------------------------------------------------
-- Bank :
-- Business Area :
-- Owner :
-------------------------------------------------------------------------------------------------------------
-- ID Date Name, Company Issue Change Log or Description
-------------------------------------------------------------------------------------------------------------
-- 001
--------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
-- main currency to a country
-- - input: country id
-- - ouput: main currency ID
-----------------------------------------------------------------------------------
function get_main_curry_id
(
i_country_id in number
)
return number
is
l_curry_id number;
begin
select curry_id
into l_curry_id
from curry_country
where country_id = i_country_id
and is_main_curry = '+'
and rownum = 1
;
return l_curry_id;
end get_main_curry_id;
end RBSC$CURRY_COUNTRY ;
