[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select s.proposed_salary_n* ppb.pay_annualization_factor salary
-- nvl(ppb.pay_annualization_factor,tpt.number_per_fiscal_year) salary -- bug 3547581
, pet.input_currency_code salary_currency_code
from pay_element_types_f pet
, pay_input_values_f piv
, per_pay_bases ppb
--, per_time_period_types tpt -- bug 3547581
--, pay_all_payrolls_f prl -- bug 3547581
, per_assignments_f a
, per_pay_proposals_v2 s
where a.assignment_type = 'E'
and a.assignment_id = p_assignment_id
and p_effective_date between a.effective_start_date and a.effective_end_date
and s.change_date IN (select max(ppp2.change_date)
from per_pay_proposals_v2 ppp2
where ppp2.change_date <= p_effective_date
and ppp2.assignment_id = a.assignment_id)
and a.pay_basis_id = ppb.pay_basis_id
and ppb.input_value_id = piv.input_value_id
-- bug 3547581
/*and s.change_date between
prl.effective_start_date and prl.effective_end_date
and a.payroll_id=prl.payroll_id
and prl.period_type=tpt.period_type */
and p_effective_date between
piv.effective_start_date and piv.effective_end_date
and piv.element_type_id = pet.element_type_id
and p_effective_date between
pet.effective_start_date and pet.effective_end_date
and a.assignment_id = s.assignment_id
and s.approved = 'Y'
order by a.assignment_id;