680: -- Declare cursor
681: --
682: CURSOR csr_sec_grp IS
683: SELECT pbg.security_group_id
684: FROM per_business_groups pbg
685: , pay_rates pyr
686: WHERE pyr.rate_id = p_rate_id
687: AND pbg.business_group_id = pyr.business_group_id;
688: --
744: -- Declare CURSOR
745: --
746: CURSOR csr_leg_code IS
747: SELECT pbg.legislation_code
748: FROM per_business_groups pbg
749: , pay_rates pyr
750: WHERE pyr.rate_id = p_rate_id
751: AND pbg.business_group_id = pyr.business_group_id;
752: --