The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;
SELECT
FULL_NAME
FROM
PER_PEOPLE_F PPF1
WHERE PPF1.PERSON_ID = PERSON_ID_V
AND PPF1.CURRENT_EMPLOYEE_FLAG = 'Y'
AND ( TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
OR TRUNC(SYSDATE) < (
SELECT
MIN(PPF2.EFFECTIVE_START_DATE)
FROM
PER_PEOPLE_F PPF2
WHERE PPF2.PERSON_ID = PPF1.PERSON_ID
AND PPF2.CURRENT_EMPLOYEE_FLAG = 'Y' ) );
SELECT
SEGMENT1
FROM
PA_PROJECTS_ALL
WHERE PROJECT_ID = PROJECT_ID_V;
SELECT
TASK_NUMBER
FROM
PA_TASKS
WHERE TASK_ID = TASK_ID_V;
SELECT
AWARD_NUMBER
FROM
GMS_AWARDS_ALL
WHERE AWARD_ID = AWARD_ID_V;
SELECT
DEFAULT_DIST_AWARD_NUMBER
INTO L_AWARD_NUMBER
FROM
GMS_IMPLEMENTATIONS
WHERE DEFAULT_DIST_AWARD_ID = AWARD_ID_V
AND AWARD_DISTRIBUTION_OPTION = 'Y';
SELECT
NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
SELECT
ASSIGNMENT_NUMBER
FROM
PER_ASSIGNMENTS_F PAF
WHERE PAF.ASSIGNMENT_ID = TYPE
AND PAF.ASSIGNMENT_TYPE = 'E'
AND ROWNUM = 1;
SELECT
ELEMENT_GROUP_NAME
FROM
PSP_ELEMENT_GROUPS PEG
WHERE PEG.ELEMENT_GROUP_ID = TYPE
AND ROWNUM = 1;
SELECT
ELEMENT_NAME
FROM
PAY_ELEMENT_TYPES_F PET
WHERE PET.ELEMENT_TYPE_ID = TYPE
AND ROWNUM = 1;
SELECT
COUNT(1)
FROM
PSP_REPORT_TEMPLATE_DETAILS
WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
AND CRITERIA_LOOKUP_CODE = 'ORG';
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';
SELECT
COUNT(1)
FROM
PSP_REPORT_TEMPLATE_DETAILS
WHERE TEMPLATE_ID = L_TEMPLATE_ID
AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
P_ORGANIZATION_ID := ' hou.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'' ' || ' ) ';