1305: p_people_group_id number) return varchar2 is
1306: --
1307: cursor csr_lookup is
1308: select group_name
1309: from pay_people_groups
1310: where people_group_id = p_people_group_id;
1311: --
1312: v_meaning pay_people_groups.group_name%type := null;
1313: --
1308: select group_name
1309: from pay_people_groups
1310: where people_group_id = p_people_group_id;
1311: --
1312: v_meaning pay_people_groups.group_name%type := null;
1313: --
1314: begin
1315: --
1316: -- Only open the cursor if the parameter is going to retrieve anything