The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
AND ACTION_INFORMATION2='PER'
AND ACTION_INFORMATION1='PYFITELA'
AND ACTION_INFORMATION3 = csr_v_pa_id
ORDER BY action_information8;
SELECT ACTION_INFORMATION4 FIRST_CODE,
decode(ACTION_INFORMATION6,null,
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))
,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION5),'DDMMYY'))||
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION6),'DDMMYY')) ) FIRSTDATEPAIR,
ACTION_INFORMATION7 SECOND_CODE,
decode(ACTION_INFORMATION9,null,
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))
,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION8),'DDMMYY'))||
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION9),'DDMMYY')) ) SECONDDATEPAIR,
ACTION_INFORMATION10 THIRD_CODE,
decode(ACTION_INFORMATION12,null,
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))
,(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION11),'DDMMYY'))||
(to_CHAR(fnd_date.canonical_to_date(ACTION_INFORMATION12),'DDMMYY')) ) THIRDDATEPAIR
, PAI.*
FROM PAY_ACTION_INFORMATION PAI
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY='EMEA REPORT INFORMATION'
AND ACTION_INFORMATION2='PER1'
AND ACTION_INFORMATION1='PYFITELA'
AND ACTION_INFORMATION3 = csr_v_pa_id
AND ACTION_INFORMATION30 = CSR_V_PERSON_ID
ORDER BY action_information5 desc;
SELECT *
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'PA'
AND ACTION_INFORMATION_CATEGORY='EMEA REPORT DETAILS'
AND ACTION_INFORMATION1='PYFITELA'
AND ACTION_CONTEXT_ID=csr_v_pa_id ;
SELECT *
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'AAP'
AND ACTION_INFORMATION_CATEGORY ='EMEA REPORT INFORMATION'
AND ACTION_INFORMATION1 ='PYFITELA'
AND ACTION_INFORMATION2 ='PERSON_EIT'
AND ACTION_INFORMATION3 = csr_v_pa_id
AND ACTION_INFORMATION6 = CSR_V_COLUMN_NAME
AND ACTION_INFORMATION30 = CSR_V_PERSON_ID;
select PERSON_EXTRA_INFO_ID,
object_version_number,
person_id,
information_type,
pei_information_category,
pei_information1,
pei_information2,
pei_information3,
pei_information4,
pei_information5,
pei_information6,
pei_information7
from per_people_extra_info
where information_type='FI_PENSION'
AND PEI_INFORMATION_CATEGORY='FI_PENSION'
AND PEI_INFORMATION3=CSR_V_COLUMN_NAME
AND PERSON_ID = CSR_V_PERSON_ID;
SELECT DISTINCT(ACTION_INFORMATION3) "FOUND"
FROM PAY_ACTION_INFORMATION pai
WHERE pai.ACTION_CONTEXT_TYPE = 'AAP'
AND pai.ACTION_INFORMATION_CATEGORY ='EMEA REPORT INFORMATION'
AND pai.ACTION_INFORMATION2 ='PERSON_EIT'
AND pai.ACTION_INFORMATION1 ='PYFITELA'
AND pai.ACTION_INFORMATION3 = csr_v_pa_id
AND pai.ACTION_INFORMATION30 = CSR_V_PERSON_ID
AND pai.ACTION_INFORMATION8 ='N'
AND pai.ACTION_INFORMATION9 = decode (pai.ACTION_INFORMATION6,
'Pension Joining Date','I',
'Local Unit','U',
'Pension Group','U',
'Insurance Number','U') ;
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;
hr_person_extra_info_api.update_person_extra_info
(
p_person_extra_info_id => lr_PERSON_EIT.person_extra_info_id,
p_object_version_number => L_OVN,
-- p_pei_information_category => lr_PERSON_EIT.pei_information_category,
-- p_pei_information1 => lr_PERSON_EIT.pei_information1,
p_pei_information2 => LR_REPORT_DETAILS.ACTION_INFORMATION9,
-- p_pei_information3 => lr_PERSON_EIT.pei_information3,
p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION9,
p_pei_information5 => 'Y'
-- p_pei_information6 => 'U',
-- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
);
hr_person_extra_info_api.update_person_extra_info
(
p_person_extra_info_id => lr_PERSON_EIT.person_extra_info_id,
p_object_version_number => L_OVN,
-- p_pei_information_category => lr_PERSON_EIT.pei_information_category,
-- p_pei_information1 => lr_PERSON_EIT.pei_information1,
p_pei_information2 => LR_REPORT_DETAILS.ACTION_INFORMATION9,
-- p_pei_information3 => lr_PERSON_EIT.pei_information3,
p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION27,
p_pei_information5 => 'Y'
-- p_pei_information6 => 'U',
-- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
);
hr_person_extra_info_api.update_person_extra_info
(
p_person_extra_info_id => lr_PERSON_EIT.person_extra_info_id,
p_object_version_number => L_OVN,
-- p_pei_information_category => lr_PERSON_EIT.pei_information_category,
-- p_pei_information1 => lr_PERSON_EIT.pei_information1,
p_pei_information2 => LR_REPORT_DETAILS.ACTION_INFORMATION9,
-- p_pei_information3 => lr_PERSON_EIT.pei_information3,
p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION26,
p_pei_information5 => 'Y'
-- p_pei_information6 => 'U',
-- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
);
hr_person_extra_info_api.update_person_extra_info
(
p_person_extra_info_id => lr_PERSON_EIT.person_extra_info_id,
p_object_version_number => L_OVN,
-- p_pei_information_category => lr_PERSON_EIT.pei_information_category,
-- p_pei_information1 => lr_PERSON_EIT.pei_information1,
p_pei_information2 => LR_REPORT_DETAILS.ACTION_INFORMATION9,
-- p_pei_information3 => lr_PERSON_EIT.pei_information3,
p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION21,
p_pei_information5 => 'Y'
-- p_pei_information6 => 'U',
-- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
);
hr_person_extra_info_api.update_person_extra_info
(
p_person_extra_info_id => lr_PERSON_EIT.person_extra_info_id,
p_object_version_number => L_OVN,
-- p_pei_information_category => lr_PERSON_EIT.pei_information_category,
-- p_pei_information1 => lr_PERSON_EIT.pei_information1,
p_pei_information2 => LR_REPORT_DETAILS.ACTION_INFORMATION9,
-- p_pei_information3 => lr_PERSON_EIT.pei_information3,
p_pei_information4 => lr_TEL_PERSON_DETAILS.ACTION_INFORMATION28,
p_pei_information5 => 'Y'
-- p_pei_information6 => 'U',
-- p_pei_information7 =>FND_DATE.DATE_TO_CANONICAL(LR_REPORT_DETAILS.ACTION_INFORMATION8 )
);