1100: CURSOR c_all_bg is
1101: select distinct
1102: pbg.business_group_id id
1103: , to_char(pbg.business_group_id) name
1104: from per_business_groups pbg;
1105: --
1106: CURSOR c_seqno is
1107: select hxt_seqno.nextval
1108: from dual;
1234: CURSOR c_all_bg is
1235: select distinct
1236: pbg.business_group_id id
1237: , to_char(pbg.business_group_id) name
1238: from per_business_groups pbg;
1239: --
1240: CURSOR c_seqno is
1241: select hxt_seqno.nextval
1242: from dual;
1748: CURSOR c_all_bg is
1749: select distinct
1750: pbg.business_group_id id
1751: , to_char(pbg.business_group_id) name
1752: from per_business_groups pbg;
1753: --
1754: CURSOR c_seqno is
1755: select hxt_seqno.nextval
1756: from dual;