The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COLUMN_PROMPT, Column_ORDER
FROM PA_STATUS_COLUMN_SETUP
WHERE FOLDER_CODE='T'
AND COLUMN_PROMPT IS NOT NULL;
SELECT COLUMN_PROMPT, Column_ORDER
FROM PA_STATUS_COLUMN_SETUP
WHERE FOLDER_CODE='R'
AND COLUMN_PROMPT IS NOT NULL;
UPDATE ak_region_items
SET node_display_flag = 'N'
WHERE region_code in ('PJM_ALL_PROJ_STATUS',
'PJM_ALL_PROJ_TASK_STATUS',
'PJM_ALL_PROJ_RSRC_STATUS')
AND object_attribute_flag = 'Y';
update ak_region_items
set node_display_flag = 'Y'
where region_code = 'PJM_ALL_PROJ_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
update ak_region_items_tl
set attribute_label_long = substr(var_column_prompt,1,50)
where region_code = 'PJM_ALL_PROJ_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
update ak_region_items
set node_display_flag = 'Y'
where region_code = 'PJM_ALL_PROJ_TASK_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
update ak_region_items_tl
set attribute_label_long = substr(var_column_prompt,1,50)
where region_code = 'PJM_ALL_PROJ_TASK_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
update ak_region_items
set node_display_flag = 'Y'
where region_code = 'PJM_ALL_PROJ_RSRC_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
update ak_region_items_tl
set attribute_label_long = substr(var_column_prompt,1,50)
where region_code = 'PJM_ALL_PROJ_RSRC_STATUS'
and substr(attribute_code,7) = to_char(var_column_order);
END UPDATE_PA_STATUS_REGIONS;
END PJM_UPDATE_AK_REGION_ITEMS_PKG;