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_ORGANIZATION_ID := ' and hrou.organization_id IN (select criteria_value1 from psp_report_template_details
where template_id = ' || P_ORG_TEMPLATE_ID || '
and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
and criteria_lookup_code = ''ORG'' ' || ' ) ';
P_PAYROLL_ID := ' and pelh.payroll_id IN (select criteria_value1 from psp_report_template_details
where template_id = ' || P_PAY_TEMPLATE_ID || '
and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
and criteria_lookup_code = ''PAY'' ' || ' ) ';
SELECT
NAME
INTO L_PROJECT_NAME
FROM
PA_PROJECTS_ALL
WHERE PROJECT_ID = PROJECT_ID1;
SELECT
TASK_NUMBER
INTO L_TASK_NUMBER
FROM
PA_TASKS_EXPEND_V -- Bug : 16391366 (20/03/2013)
WHERE TASK_ID = TASK_ID1;
SELECT
AWARD_NUMBER
INTO L_AWARD_NUMBER
FROM
GMS_AWARDS_ALL
WHERE AWARD_ID = AWARD_ID1;
SELECT
NAME
INTO L_ORG_NAME
FROM
HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
SELECT
GA.END_DATE_ACTIVE
FROM
GMS_AWARDS GA
WHERE GA.AWARD_ID = AWARD_ID1;