DBA Data[Home] [Help]

APPS.AME_APT_BUS dependencies on AME_CONDITIONS

Line 269: from AME_CONDITIONS cond

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

Line 343: -- AME_CONDITIONS

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