570: --
571: cursor bus_c(p_id number)
572: is
573: select name
574: from per_business_groups_perf
575: where business_group_id = p_id
576: ;
577:
578: l_business_group_id per_business_groups.business_group_id%type ;
3012:
3013:
3014: cursor c_bg_name(p_business_group_id number) is
3015: select name
3016: from per_business_groups_perf bg
3017: where business_group_id = p_business_group_id ;
3018:
3019: cursor c_org_name(p_org_id number) is
3020: select name