ID NO:

Employee Code:

Employee Name :

Gender :

Designation :

Grade :

Company:

Cost Center :

Department :

Section :

Work Station :

Unit :

Sub Unit :

Employment Type :

Class :

First Reporting Supervisor :

Date Of Joining :

Job Location :

Select ID First :

select o.id,p.PBI_NAME,p.PBI_ID,p.DEPT_ID,p.PBI_CODE,p.cost_center,p.section, o.s_time,o.e_time,o.s_date as start_date,o.e_date as end_date,o.type, o.iom_apply_date,o.total_days,o.dept_head_status,o.iom_status,o.reason,p.incharge_id,o.entry_at from personnel_basic_info p,hrm_iom_info o where p.PBI_ID=o.PBI_ID and o.dept_head_status!="Cancel" and o.iom_status="Pending" order by o.s_date desc

Mark	SL NO	ID NO	Name	Cost Centre	Department	Sectiom	Type	Application Date	Applied From	Applied To	Total Days	Reasons	Reporting Supervisor Name	Reporting Authority	HR Approval

Select All