The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PDB.DEFINED_BALANCE_ID
FROM
PAY_BALANCE_DIMENSIONS PBD,
PAY_BALANCE_TYPES PBT,
PAY_DEFINED_BALANCES PDB
WHERE PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBT.BALANCE_NAME = L_BALANCE_NAME
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND PBD.DATABASE_ITEM_SUFFIX = '_ASG_TWO_YTD'
AND PBT.LEGISLATION_CODE = 'IE';
SELECT
NAME
INTO
CP_BUSINESS_GROUP_NAME
FROM
PER_BUSINESS_GROUPS
WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;
SELECT
PAYROLL_NAME
FROM
PAY_PAYROLLS_F
WHERE PAYROLL_ID = VP_PAYROLL_ID;