APPS.PA_PERF_NOTIFICATION_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 79

     SELECT pa_workflow_itemkey_s.nextval
     INTO l_item_key
     FROM dual;

Line: 128

     PA_WORKFLOW_UTILS.Insert_WF_Processes(
                     p_wf_type_code           => l_wf_type_code
                    ,p_item_type              => p_item_type
                    ,p_item_key               => l_item_key
                    ,p_entity_key1            => l_entity_key1
                    ,p_entity_key2            => l_entity_key2
                    ,p_description            => p_process_name
                    ,p_err_code               => l_err_code
                    ,p_err_stage              => l_err_stage
                    ,p_err_stack              => l_err_stack
                    );

Line: 254

  SELECT object_page_layout_id,
         object_id,
         object_type,
         page_name,
         page_id,
         page_type_code,
	 report_name
  FROM pa_progress_report_setup_v
  WHERE object_id = c_object_id
  AND object_type = 'PA_PROJECTS'
  AND page_type_code='PPR'
  AND generation_method='AUTOMATIC';

Line: 304

     SELECT name, segment1 INTO l_project_name, l_project_number
     FROM pa_projects_all
     WHERE project_id=p_project_id;