DBA Data[Home] [Help]

APPS.AZW_ARCHIVE dependencies on AZ_ARCHIVE_STEPS

Line 35: from az_archive_steps aas

31: IS
32: cnt number DEFAULT 0;
33: BEGIN
34: select count(*) into cnt
35: from az_archive_steps aas
36: where aas.item_key = p_item_key
37: and aas.activity_type = p_activity_type
38: and aas.step = p_step
39: and aas.begin_date = p_begin_date;

Line 318: INSERT into az_archive_steps

314: l_item_key := each_task.item_key;
315: FOR each_step in all_steps_cursor LOOP
316: if(is_step_notfound(each_task.item_key, each_step.type
317: ,each_step.name, each_step.begin_date)) then
318: INSERT into az_archive_steps
319: (item_key
320: ,activity_type
321: ,step, step_name
322: ,assigned_user, assigned_user_name