53: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
54:
55: Cursor cur_noa_id is
56: select 1 57: from ghr_noa_families noa 58: where noa.nature_of_action_id = p_first_nature_of_action_id
59: and noa.noa_family_code = p_noa_family_code
60: and l_effective_date
61: between nvl(noa.start_date_active,l_effective_date)