[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select action_information2 business_group_id, action_information3 legal_employer_id,
action_information4
legal_employer_name, action_information5 legal_empl_y_num,
action_information6 local_unit_id, action_information7 local_unit_name, action_information8 local_unit_sd_no,
action_information9
year, effective_date
from pay_action_information pai
where action_context_type = 'PA'
and action_context_id = p_payroll_action_id
and action_information_category = 'EMEA REPORT DETAILS'
and action_information1 = 'PYFIPSTA';
select action_information3 business_group_id, action_information4 legal_employer_id,
action_information5
local_unit_id, action_information6 local_unit_name, action_information7 local_unit_sd_no,
action_information8
address_line_1, action_information9 address_line_2, action_information10 address_line_3,
action_information11
country, action_information12 postal_code, effective_date
from pay_action_information pai
where action_context_type = 'PA'
and action_context_id = p_payroll_action_id
and action_information_category = 'EMEA REPORT INFORMATION'
and action_information1 = 'PYFIPSTA'
-- and action_information6 = 'FI Local Unit1'
and action_information2 = 'LU_DETAILS';
select count (*)
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 pai.action_context_type = 'AAP'
and pai.action_information_category = 'EMEA REPORT INFORMATION'
and pai.action_information1 = 'PYFIPSTA'
and action_information2 = 'PERSON DETAILS'
and pai.action_information20 = p_local_unit_id;
select action_information3 person_id, action_information4 pin, action_information5 emp_name,
action_information6
employee_number, action_information7 salary_basis, action_information8 tax_card_type,
action_information9
tax_municipality, action_information10 base_rate, action_information11 additional_rate,
action_information12
yearly_income_limit, action_information13 actual_tax_days,
action_information14 insurance_salary, action_information15 address_line1,
action_information16
address_line2, action_information17 address_line3, action_information18 postal_code,
action_information19
country, fnd_date.canonical_to_date (action_information21) date_of_birth,
action_information22
job_name, action_information23 permanent_address_line1,
action_information24 permanent_address_line2, action_information25 permanent_address_line3,
action_information26
permanent_postal_code, action_information27 permanent_country
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 pai.action_context_type = 'AAP'
and pai.action_information_category = 'EMEA REPORT INFORMATION'
and action_information1 = 'PYFIPSTA'
and action_information2 = 'PERSON DETAILS'
and action_information20 = p_local_unit_id
-- and action_information3 = to_char(20435)
order by to_number (person_id);
select action_information4 payroll_id, action_information5 pay_period,
fnd_date.canonical_to_date (action_information6)
pay_period_start_date,
fnd_date.canonical_to_date (action_information7) pay_period_end_date, action_information8 period_type,
fnd_number.canonical_to_number (action_information9)
salary_income,
fnd_number.canonical_to_number (action_information10) benefits_in_kind, action_information11 benefit_type,
fnd_number.canonical_to_number (action_information12)
benefit_monetary_value,
fnd_number.canonical_to_number (action_information13) sal_sub_tax,
fnd_number.canonical_to_number (action_information14)
tax_amount,
fnd_number.canonical_to_number (action_information15) net_salary,
fnd_number.canonical_to_number (action_information16)
deductions_b_tax,
fnd_number.canonical_to_number (action_information17) external_compensation,
fnd_number.canonical_to_number (action_information18)
time_period_id,
fnd_number.canonical_to_number (action_information19) pension,
fnd_number.canonical_to_number (action_information20)
unemployment_insurance,
fnd_number.canonical_to_number (action_information21) trade_union_fee,
fnd_number.canonical_to_number (action_information22)
car_benefit
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 pai.action_context_type = 'AAP'
and pai.action_information_category = 'EMEA REPORT INFORMATION'
and action_information1 = 'PYFIPSTA'
and action_information2 = 'Payroll Details'
and action_information3 = p_person_id
order by time_period_id asc;
select fnd_date.canonical_to_date (action_information6) pay_period_start_date,
fnd_date.canonical_to_date (action_information7)
pay_period_end_date, action_information11 benefit_type,
fnd_number.canonical_to_number (action_information12)
benefit_value
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 pai.action_context_type = 'AAP'
and pai.action_information_category = 'EMEA REPORT INFORMATION'
and action_information1 = 'PYFIPSTA'
and action_information2 = 'Benefit Details'
and action_information3 = p_person_id
and action_information11 is not null
--group by action_information18,action_information5,action_information6,action_information7,action_information8,action_information11,action_information21
order by benefit_type; --, to_number(nvl(benefits_in_kind,0)) desc;
select fnd_date.canonical_to_date (action_information6) car_pay_period_start_date,
fnd_date.canonical_to_date (action_information7)
car_pay_period_end_date,
action_information19 input_value_name, action_information20 input_value,
action_information22
input_value_uom
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 pai.action_context_type = 'AAP'
and pai.action_information_category = 'EMEA REPORT INFORMATION'
and action_information1 = 'PYFIPSTA'
and action_information2 = 'Car Benefit Details'
and action_information3 = p_person_id
and action_information19 is not null
order by car_pay_period_start_date; --, to_number(nvl(benefits_in_kind,0)) desc;
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 sysdate
into l_report_date
from dual;