APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_PROC_HIERARCHY_DENORM

Line 640: from amw_process amwp, Amw_Proc_Hierarchy_Denorm apdenorm

636: loop
637:
638: select nvl(sum(risk_count), 0), nvl(sum(control_count), 0)
639: into l_risk_count, l_control_count
640: from amw_process amwp, Amw_Proc_Hierarchy_Denorm apdenorm
641: where apdenorm.process_id = v_index
642: and apdenorm.up_down_ind = 'D'
643: and amwp.process_id = apdenorm.parent_child_id;
644:

Line 2774: delete from Amw_Proc_Hierarchy_Denorm;

2770: -- for tables of large size, that itself is expensive, and would counter the gains
2771: -- obtained by bulk insert. If further performance problem is reported, we'll
2772: -- try out these tricks.
2773: begin
2774: delete from Amw_Proc_Hierarchy_Denorm;
2775: open c12;
2776: loop
2777: fetch c12 bulk collect into v_ap_id;
2778: exit when c12%notfound;

Line 2793: from Amw_Proc_Hierarchy_Denorm

2789: FOR i IN 1..v_parent_id.count LOOP
2790: l_parent_id := v_parent_id(i);
2791: begin
2792: select 1 into l_dummy
2793: from Amw_Proc_Hierarchy_Denorm
2794: where Process_Id = l_process_id
2795: and Parent_Child_Id = l_parent_id
2796: and Up_Down_Ind = 'U';
2797: exception

Line 2799: insert into Amw_Proc_Hierarchy_Denorm

2795: and Parent_Child_Id = l_parent_id
2796: and Up_Down_Ind = 'U';
2797: exception
2798: when no_data_found then
2799: insert into Amw_Proc_Hierarchy_Denorm
2800: (Process_Id,
2801: Parent_Child_Id,
2802: Up_Down_Ind,
2803: Last_Update_Date,

Line 2831: from Amw_Proc_Hierarchy_Denorm

2827: FOR i IN 1..v_child_id.count LOOP
2828: l_child_id := v_child_id(i);
2829: begin
2830: select 1 into l_dummy
2831: from Amw_Proc_Hierarchy_Denorm
2832: where Process_Id = l_process_id
2833: and Parent_Child_Id = l_child_id
2834: and Up_Down_Ind = 'D';
2835: exception

Line 2837: insert into Amw_Proc_Hierarchy_Denorm

2833: and Parent_Child_Id = l_child_id
2834: and Up_Down_Ind = 'D';
2835: exception
2836: when no_data_found then
2837: insert into Amw_Proc_Hierarchy_Denorm
2838: (Process_Id,
2839: Parent_Child_Id,
2840: Up_Down_Ind,
2841: Last_Update_Date,