[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;
CURSOR csr_legal_employer is select o.name,fnd_date.canonical_to_date(pai.action_information5) action_information5
from
HR_ORGANIZATION_UNITS o,
HR_ORGANIZATION_INFORMATION hoi1,
pay_action_information pai
where pai.action_context_id = l_payroll_action_id
and pai.action_information_category ='EMEA REPORT DETAILS'
and o.organization_id = pai.action_information2
and hoi1.organization_id = o.organization_id
and hoi1.org_information_context = 'CLASS'
and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER';
select pai.action_information1 report_type,
pai.action_information3 quater,
pai.action_information4 possible_working_days,
pai.action_information5 sex,
pai.action_information6 occur_1_3_days_sc,
pai.action_information7 sc_1_3_abs_days,
pai.action_information8 dc_1_3_days_Occur,
pai.action_information9 dc_1_3_abs_days,
pai.action_information10 sick_4_16_days_Occur,
pai.action_information11 sick_4_16_abs_days,
pai.action_information12 More_Than_16days_Occur,
pai.action_information13 More_Than_16days_Abs,
pai.action_information14 Child_Minders_Ocrs,
pai.action_information15 Child_Minders_Days,
pai.action_information16 Paternal_Leave_ocrs,
pai.action_information17 Paternal_leave_days,
pai.action_information18 other_leave_ocrs,
pai.action_information19 other_leave_days,
pai.action_information20 sick_more_8w_ocrs,
pai.action_information21 sick_more_8w_days,
pai.action_information22 other_abs_paid_ocrs,
pai.action_information23 other_abs_paid_days,
pai.action_information24 business_group_id
from pay_action_information pai
where pai.action_context_id = csr_v_pa_id
and action_information_category ='EMEA REPORT INFORMATION'
and action_information1 = 'PYNOABSA'
order by pai.action_information3;