786: is
787: --
788: cursor csr_default_currency is
789: select currency_code
790: from per_business_groups_perf
791: where business_group_id = p_business_group_id;
792: --
793: currency per_business_groups_perf.currency_code%type;
794: --
789: select currency_code
790: from per_business_groups_perf
791: where business_group_id = p_business_group_id;
792: --
793: currency per_business_groups_perf.currency_code%type;
794: --
795: begin
796: --
797: open csr_default_currency;
1438: into p_legislation_code
1439: , p_short_name
1440: , p_bg_name
1441: , p_bg_currency_code
1442: from per_business_groups b
1443: where b.business_group_id = p_business_group_id;
1444: exception
1445: when no_data_found then
1446: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');