[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_information4) 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.assignment_id,
pai.action_information1,
pai.action_information2 employee_number,
pai.action_information3 full_name,
pai.action_information4 sc_days
FROM pay_action_information pai
,pay_assignment_actions paa
WHERE pai.action_context_id = paa.assignment_action_id
AND paa.payroll_action_id = csr_v_pa_id
AND action_information_category ='EMEA REPORT INFORMATION'
AND action_information1 = 'PYNOSFCA';