The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'PA'
AND ACTION_CONTEXT_ID = csr_v_pa_id
AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
AND ACTION_INFORMATION1='PYNORSEA';
SELECT *
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'PA'
AND ACTION_CONTEXT_ID = csr_v_pa_id
AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
AND ACTION_INFORMATION1='PYNORSEA'
AND ACTION_INFORMATION2='M';
SELECT SUM(action_information6) Witholding_Tax, SUM(action_information7) u_contribution_basis, SUM(action_information8) o_contribution_basis
, SUM(action_information20) fe_spr_contribution_basis, SUM(action_information21) fe_spr_calc_contribution
, SUM(action_information25) fe_fma_calc_contribution , SUM(action_information11) u_calc_contribution, SUM(action_information12) o_calc_contribution
, SUM(action_information26) lu_el_used , SUM(action_information27) lu_el_used_bimonth , SUM(action_information23) no_month
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'PA'
AND ACTION_CONTEXT_ID = csr_v_pa_id
AND ACTION_INFORMATION_CATEGORY= 'EMEA REPORT INFORMATION'
AND ACTION_INFORMATION1='PYNORSEA'
AND ACTION_INFORMATION2='M';
SELECT payroll_action_id
INTO l_payroll_action_id
FROM pay_payroll_actions ppa,
fnd_conc_req_summary_v fcrs,
fnd_conc_req_summary_v fcrs1
WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
AND fcrs.priority_request_id = fcrs1.priority_request_id
AND ppa.request_id between fcrs1.request_id and fcrs.request_id
AND ppa.request_id = fcrs1.request_id;