265: where orig_system = p_orig_system;
266: --
267: Cursor c_sel4 is
268: select null
269: from AME_CONDITIONS cond
270: ,WF_ROLES wfr
271: where cond.parameter_two = wfr.name
272: and wfr.orig_system = p_orig_system
273: and p_effective_date between cond.start_date
339: hr_multi_message.add;
340: end if;
341: close c_sel3;
342: --
343: -- AME_CONDITIONS
344: --
345: open c_sel4;
346: fetch c_sel4 into l_exists;
347: if c_sel4%found then