APPS.MRP_MSC_EXP_WF dependencies on WF_ITEMS

Line 1001: ' FROM wf_items' ||

997: BEGIN
998:
999: l_item_type := 'MRPEXWFS';
1000: sql_stmt := ' SELECT item_key ' ||
1001: ' FROM wf_items' ||
1002: ' WHERE item_type = :l_item_type' ||
1003: ' AND item_key like '''|| to_char(arg_plan_id) || '-%''';
1004:
1005: OPEN delete_activities_c for sql_stmt using l_item_type;

Line 1027: update wf_items

1023: from wf_item_activity_statuses_h
1024: where item_type = 'MRPEXWFS'
1025: and item_key = l_item_key);
1026:
1027: update wf_items
1028: set end_date = sysdate
1029: where item_type = 'MRPEXWFS'
1030: and item_key = l_item_key;
1031: