The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DECODE(COUNT(PAA.ASSIGNMENT_ID)
,0
,'F'
,'T')
INTO P_FLAG
FROM
PAY_ASSIGNMENT_ACTIONS PAA,
PAY_PAYROLL_ACTIONS PACT
WHERE PACT.EFFECTIVE_DATE <= TO_DATE('31-12-' || P_TAX_YEAR
,'DD-MM-YYYY')
AND PACT.EFFECTIVE_DATE >= TO_DATE('01-01-' || P_TAX_YEAR
,'DD-MM-YYYY')
AND PACT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
AND PACT.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PACT.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' )
AND PAA.TAX_UNIT_ID = P_TAX_UNIT_ID;
SELECT
ORG_INFORMATION2
FROM
HR_ORGANIZATION_INFORMATION
WHERE ORGANIZATION_ID = TAX_UNIT_ID
AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
AND ORG_INFORMATION1 = STATE_CODE;
SELECT
D_TAX_OTD_VALUE,
D_WAGE_OTD_VALUE,
D_FORMAT_CODE
FROM
PAY_US_FEDERAL_TAX_BAL_GRE_V
WHERE D_BALANCE_SET_NAME = '940_FED_YTD'
AND D_TAX_UNIT_ID = P_TAX_UNIT_ID;
SELECT
ORG_INFORMATION6,
ORG_INFORMATION7
FROM
HR_ORGANIZATION_INFORMATION
WHERE ORGANIZATION_ID = TAX_UNIT_ID
AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
AND ORG_INFORMATION1 = STATE_CODE;
CP_SELECT_COL1 := NULL;
CP_SELECT_COL2 := NULL;
CP_SELECT_COL1 := 'v.d_wage_otd_value ';
CP_SELECT_COL2 := 'v.d_tax_unit_id ';
CP_SELECT_COL1 := '1 ';
CP_SELECT_COL2 := 'v.tax_unit_id ';
SELECT
DISTINCT
SUBSTR(D_STATE_CODE
,1
,2),
D_WAGE_OTD_VALUE
FROM
PAY_US_STATE_TAX_BAL_GRE_V
WHERE D_STATE_CODE = '33-000-0000'
AND D_BALANCE_SET_NAME = '940_STATE_YTD'
AND D_TAX_TYPE = 'FUTA'
AND D_TAX_UNIT_ID = TAX_UNIT_ID;