27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: ,ota_bkng_justifications_b bjs
33: where bjs.booking_justification_id = p_booking_justification_id
34: and pbg.business_group_id = bjs.business_group_id;
35: --
99: -- Declare cursor
100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , ota_bkng_justifications_b bjs
105: where bjs.booking_justification_id = p_booking_justification_id
106: and pbg.business_group_id = bjs.business_group_id;
107: --