select EMPLOYEE_NUMBER,
a.FULL_NAME,
x.USER_PERSON_TYPE,
c.PROPOSED_SALARY_n Basi_Salary–,
c.CHANGE_DATE,
c.*
from per_people_f A,
per_assignments_f b,
pER_PAY_pROposals c,
per_person_types x,
per_person_type_usages_f e
where a.PERSON_ID = b.PERSON_ID
and b.ASSIGNMENT_ID = C.ASSIGNMENT_ID
and a.EMPLOYEE_NUMBER is not null –and
a.EMPLOYEE_NUMBER = :emp_num
and c.CHANGE_DATE = (select max(d.CHANGE_DATE)
from pER_PAY_pROposals d
where d.ASSIGNMENT_ID = b.ASSIGNMENT_ID
and d.approved = ‘Y’) –and
c.CHANGE_DATE >= :change_date
and b.PAYROLL_ID = 62
and :p_effective_date between a.EFFECTIVE_START_DATE and
a.EFFECTIVE_END_DATE
and :p_effective_date between b.EFFECTIVE_START_DATE and
b.EFFECTIVE_END_DATE
and a.PERSOn_id = e.PERSON_ID
and a.EFFECTIVE_START_DATE between e.EFFECTIVE_START_DATE and
e.EFFECTIVE_END_DATE
and e.PERSON_TYPE_ID = x.PERSON_TYPE_ID
and x.SYSTEM_PERSON_TYPE = 'EMP'
