[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hr_ni_chk_pkg.chk_nat_id_format(per.national_identifier, 'DDDDDD-DDDDDDD') NATIONAL_IDENTIFIER,
per.person_id, -- bug 6012258
pds.date_start,
pds.actual_termination_date,
ppa.effective_date
from per_people_f per,
per_periods_of_service pds,
per_assignments_f asg,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and asg.assignment_id = paa.assignment_id
and ppa.effective_date
between asg.effective_start_date and asg.effective_end_date
and pds.period_of_service_id = asg.period_of_service_id
and per.person_id = pds.person_id
and ppa.effective_date
between per.effective_start_date and per.effective_end_date;
select to_number(pi.aei_information13) "Cash Receipt"
from per_assignment_extra_info pi,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and pi.assignment_id = paa.assignment_id
and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
= trunc(ppa.effective_date, 'YYYY');
select aei_information2 emp_med_exp_nts,
aei_information3 emp_educ_exp_nts,
aei_information4 emp_card_exp_nts,
aei_information5 emp_don_exp_nts,
aei_information6 emp_ins_exp_nts -- Bug 5667762
from per_assignment_extra_info pei,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and pei.assignment_id = paa.assignment_id
and pei.information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
and trunc(fnd_date.canonical_to_date(pei.aei_information1), 'YYYY')
= trunc(ppa.effective_date, 'YYYY');
select nvl(to_number(aei_information18), 0) + nvl(to_number(aei_information19), 0) +
nvl(to_number(aei_information20), 0) + nvl(to_number(aei_information22), 0) +
nvl(to_number(aei_information23), 0) + nvl(to_number(aei_information30), 0)
from per_assignment_extra_info pi,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and pi.assignment_id = paa.assignment_id
and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
= trunc(ppa.effective_date, 'YYYY');
select nvl(to_number(aei_information7), 0) + nvl(to_number(aei_information10), 0)
+ nvl(to_number(aei_information12), 0)
from per_assignment_extra_info pi,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and pi.assignment_id = paa.assignment_id
and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
= trunc(ppa.effective_date, 'YYYY');
select nvl(to_number(aei_information4), 0) +
nvl(to_number(aei_information5), 0) +
nvl(to_number(aei_information6), 0),
nvl(to_number(aei_information2),0)
from per_assignment_extra_info pi,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and pi.assignment_id = paa.assignment_id
and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
= trunc(ppa.effective_date, 'YYYY');
select paa.assignment_id, ppa.effective_date
from pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id;
select sum(nvl(to_number(cei.cei_information9),0))
from pay_kr_cont_details_v pkc,
per_contact_extra_info_f cei -- Bug 5879106
where pkc.assignment_id = p_assignment_id
and p_effective_date between emp_start_date and emp_end_date
and p_effective_date between cont_start_date and cont_end_date
and cei.information_type(+) = 'KR_DPNT_EXPENSE_INFO'
and cei.contact_relationship_id(+) = pkc.contact_relationship_id
and to_char(cei.effective_start_date(+), 'YYYY') = to_char(p_effective_date, 'YYYY')
and p_effective_date between nvl(ADDRESS_START_DATE, p_effective_date) and nvl(ADDRESS_END_DATE, p_effective_date)
and p_effective_date between nvl(pkc.date_start, p_effective_date)
and decode(pkc.cont_information9, 'D', trunc(add_months(nvl(pkc.date_end, p_effective_date),12),'YYYY')-1, nvl(pkc.date_end, p_effective_date) )
and pay_kr_ff_functions_pkg.is_exempted_dependent( pkc.contact_type,
pkc.national_identifier,
pkc.cont_information2,
pkc.cont_information3,
pkc.cont_information4,
pkc.cont_information7,
pkc.cont_information8,
p_effective_date,
pkc.cont_information10,
pkc.cont_information12,
pkc.cont_information13,
pkc.cont_information14,
cei.contact_extra_info_id(+)
) = 'Y';