136: l_effective_date date := trunc(nvl(p_effective_date,sysdate));
137:
138: Cursor cur_sec_noa_id is
139: select 1 140: from ghr_dual_actions dua 141: where dua.first_noa_id = p_first_nature_of_action_id
142: and dua.second_noa_id = p_second_nature_of_action_id;
143: -- and l_effective_date
144: -- between nvl(noa.start_date_active,l_effective_date)