25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_fr_validation_periods vlp
31: , pqh_fr_validations vld
32: where vld.validation_id = vlp.validation_id
33: and vlp.validation_period_id = p_validation_period_id
91: -- Declare cursor
92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_fr_validation_periods vlp
97: , pqh_Fr_validations vld
98: where vld.validation_id = vlp.validation_id
99: and vlp.validation_period_id = p_validation_period_id