Query_to_find_emp_last_increased_salary_details

Select papf.employee_number,
papf.full_name,
XXPY_HIRING_DATA.GET_ELEMENT_AMOUNT_R(P_BUSINESS_GROUP_ID=> paaf.business_group_id
                                ,P_PAYROLL_ID => paaf.payroll_id
                                ,P_ASSIGNMENT_ID => paaf.assignment_id
                                ,P_ELEMENT_NAME => 'Basic Salary'
                                ,P_DATE => to_date('31-DEC-2014'))basic,                               
XXFUJ_PAYROLL_FUNCTIONS_II.GET_SCREEN_ENTRY_VALUE(
    P_Assignment_ID=>     paaf.assignment_id,
    P_Element_Name =>      'Basic Grand Sum',
    P_Name           =>    'Override Amount',
    P_Payroll_End_Date =>  to_date('31-DEC-2014')) grand_sum,
(select max(ppp.change_date) from per_pay_proposals ppp
where
ppp.assignment_id = paaf.assignment_id) change_date
from
per_all_people_f papf                                    
,per_all_assignments_f paaf
where papf.person_id = paaf.person_id
and to_date('31-DEC-2014') between papf.effective_start_date and papf.effective_end_date                                                                
and to_date('31-DEC-2014') between paaf.effective_start_date and paaf.effective_end_date
and papf.current_employee_flag= 'Y'
and paaf.payroll_id = 82
and papf.employee_number = 'P-1001'
--and employee_category <> 'FUJ03'
and
XXPY_HIRING_DATA.IS_ELEMENT_EXIST(P_ASSIGNMENT_ID=>paaf.assignment_id
                             ,P_DATE =>to_date('31-DEC-2014')
                             ,P_ELEMENT_NAME => 'Basic Grand Sum') = 'N'