The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fnd_date.canonical_to_date (action_information5) joinig_start_date,
fnd_date.canonical_to_date (action_information6)
joinig_end_date, action_information9 division,
action_information12 agreement_area, action_information13 empployee_category,
action_information14
assignment_category,
fnd_date.canonical_to_date (action_information16) start_date_of_birth,
fnd_date.canonical_to_date (action_information17)
end_date_of_birth,
fnd_date.canonical_to_date (action_information18) precedence_end_date,
fnd_date.canonical_to_date (action_information19)
report_date, action_information20 sort_order
FROM pay_action_information
WHERE action_context_id = p_payroll_action_id AND action_information_category = 'EMEA REPORT DETAILS';
SELECT action_information3 legal_emp_id, action_information4 legal_employer_name, action_information5 org_number,
effective_date
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 = 'PYSETRNA'
AND action_information2 = 'LE';
SELECT DISTINCT action_information14 division_code, action_information16 division
FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
WHERE paa.payroll_action_id = p_payroll_action_id
AND assg.payroll_action_id = paa.payroll_action_id
AND pai.action_context_id = assg.assignment_action_id
AND action_context_type = 'AAP'
--AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSETRNA'
AND action_information13 = p_legal_employer_id;
SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
WHERE paa.payroll_action_id = p_payroll_action_id
AND assg.payroll_action_id = paa.payroll_action_id
AND pai.action_context_id = assg.assignment_action_id
AND action_context_type = 'AAP'
--AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSETRNA'
AND action_information13 = p_legal_employer_id
AND action_information14 = p_div;
l_select_str VARCHAR2 (3000);
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 'order by '
|| decode (
nvl (rec_report_parameters.sort_order, 'EMP_TIME'),
'EMP_TIME', ' total_emp_time desc ',
'ASG_NUM', ' assignment_number asc ',
'NAME', ' full_name asc ',
'PIN', ' national_identifier asc '
)
INTO l_sort_order
FROM dual;
l_select_str :=
'SELECT action_information4 national_identifier,
action_information5
assignment_number, action_information6 full_name,
fnd_date.canonical_to_date (action_information7)
hire_date,
fnd_number.canonical_to_number (action_information8) total_emp_time,
fnd_date.canonical_to_date (action_information9)
precedence_date,
fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
action_information12
emp_sec
FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
WHERE paa.payroll_action_id = '
|| l_payroll_action_id
|| ' AND assg.payroll_action_id = paa.payroll_action_id
AND pai.action_context_id = assg.assignment_action_id
AND action_context_type = '
|| '''AAP''' || ' AND action_information_category = ' || '''EMEA REPORT INFORMATION'''
|| ' AND action_information1 = ' || '''PYSETRNA''' || ' AND action_information13 = '
|| rec_leg_emp.legal_emp_id || ' AND action_information14 = ' || '''' || rec_all_division.division_code || ''''
|| ' AND action_information15 = ' || '''' || rec_all_area.area_code || '''' || ' ' || l_sort_order;
fnd_file.put_line (fnd_file.LOG, 'l_select_str :- '||length(l_select_str));
OPEN csr_get_emp FOR l_select_str;
l_select_str := null;