The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COUNT(1)
FROM
PSP_REPORT_TEMPLATE_DETAILS
WHERE TEMPLATE_ID = P_TEMPLATE_ID
AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
P_PROJECT_ID := ' and a.project_id IN (select criteria_value1 from psp_report_template_details
where template_id = ' || P_PRJ_TEMPLATE_ID || '
and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
and criteria_lookup_code = ''PRJ'' ' || ' ) ';
SELECT
DISTINCT
NAME
INTO V_INSTITUTION_NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
SELECT
SEGMENT1
INTO V_PROJECT_NAME
FROM
PA_PROJECTS_ALL
WHERE PROJECT_ID = PROJECT_ID_arg;
SELECT
FULL_NAME
INTO V_PERSON_NAME
FROM
PER_ALL_PEOPLE_F
WHERE PERSON_ID = PERSON_ID_arg
AND P_END_DATE Between EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE;
SELECT
ASSIGNMENT_NUMBER
INTO V_ASSIGNMENT_NUMBER
FROM
PER_ASSIGNMENTS_F
WHERE ASSIGNMENT_ID = ASSIGNMENT_ID_arg
AND ( P_END_DATE Between EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE )
AND PERIOD_OF_SERVICE_ID IS NOT NULL;
SELECT
ELEMENT_NAME
INTO V_ELEMENT_NAME
FROM
PAY_ELEMENT_TYPES_F
WHERE ELEMENT_TYPE_ID = ELEMENT_TYPE_ID_arg
AND ( P_END_DATE Between EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE );
SELECT
DISTINCT
PERIOD_NAME
INTO V_PERIOD_NAME
FROM
PER_TIME_PERIODS
WHERE TIME_PERIOD_ID = TIME_PERIOD_ID_arg;
SELECT
NAME
INTO L_EXP_ORG
FROM
HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID
AND ROWNUM = 1;
SELECT
TASK_NUMBER
INTO L_TASK_NUMBER
FROM
PA_TASKS_EXPEND_V -- Bug : 16391366 (20/03/2013)
WHERE TASK_ID = TASK_ID_arg;
SELECT
AWARD_NUMBER
INTO L_AWARD_NUMBER
FROM
GMS_AWARDS_ALL
WHERE AWARD_ID = AWARD_ID_arg;