[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
SELECT pai.action_information2 Legal_Employer,
pai.action_information10 Start_Date,
pai.action_information11 End_Date,
pai2.action_information4 Local_Unit,
pai1.action_information5 ||'-' || pai2.action_information6 Company_Number,
pai4.action_information4 Element_name,
pai4.action_information6 Account_number,
nvl(pai4.action_information7,0) Credit,
nvl(pai4.action_information8,0) Debit
FROM pay_action_information pai,
pay_payroll_actions ppa,
pay_action_information pai1,
pay_action_information pai2,
pay_action_information pai4
WHERE pai.action_context_id = ppa.payroll_action_id
AND ppa.payroll_action_id = csr_v_pa_id
AND pai.action_context_id = pai1.action_context_id
AND pai1.action_context_id= pai2.action_context_id
AND pai2.action_context_id=pai4.action_context_id
AND pai4.action_context_id=pai.action_context_id
AND pai1.action_information3=pai2.action_information5
AND pai2.action_information3=pai4.action_information5
AND pai1.action_context_type='PA'
AND pai1.action_information2 = 'LE'
AND pai1.action_information1 = 'PYFIACRA'
AND pai1.action_information_category = 'EMEA REPORT INFORMATION'
AND pai.action_context_type = 'PA'
AND pai.action_information1 = 'PYFIACRA'
AND pai.action_information_category = 'EMEA REPORT DETAILS'
AND pai2.action_context_type = 'PA'
AND pai2.action_information1 = 'PYFIACRA'
AND pai2.action_information_category = 'EMEA REPORT INFORMATION'
AND pai2.action_information2 = 'LU'
AND pai4.action_context_type = 'PA'
AND pai4.action_information1 = 'PYFIACRA'
AND pai4.action_information_category = 'EMEA REPORT INFORMATION'
AND pai4.action_information2 = 'EL';