234: if p_business_group is not null then
235: begin
236: select business_group_id
237: into g_business_group_id
238: from per_business_groups_perf
239: where name = p_business_group ;
240: exception
241: when no_data_found then
242: raise ;
782: where job_id = p_val;
783:
784: cursor c_bg is
785: select name
786: from per_business_groups_perf
787: where business_group_id = p_val;
788:
789: cursor c_pos is
790: select name
1563: ;
1564:
1565: cursor c_bg is
1566: select business_group_id
1567: from per_business_groups_perf
1568: where name = p_meaning
1569: ;
1570:
1571: cursor c_pos is