284: -- Bug#5482191 Added effective date condition.
285: CURSOR get_sal_chg_fam
286: IS
287: SELECT noa_family_code 288: FROM ghr_families 289: WHERE noa_family_code IN (
290: SELECT noa_family_code
291: FROM ghr_noa_families
292: WHERE nature_of_action_id =