51: --
52: cursor csr_sec_grp is
53: select pbg.security_group_id,
54: pbg.legislation_code
55: from per_business_groups_perf pbg
56: , ota_suppliable_resources tsr
57: where tsr.supplied_resource_id = p_supplied_resource_id
58: and pbg.business_group_id = tsr.business_group_id;
59: --
1173: -- Declare cursor
1174: --
1175: cursor csr_leg_code is
1176: select legislation_code
1177: from per_business_groups_perf pbg,
1178: ota_suppliable_resources tsr
1179: where pbg.business_group_id = tsr.business_group_id
1180: and tsr.supplied_resource_id = p_supplied_resource_id;
1181: