Leave Rule
Employee Image
  • Employee Name & ID
  • Employee Designation
  • Employee Department
select a.id, a.PBI_ID as Employee_ID, a.CL as Casual_Leave,a.MED as Sick_Leave, a.ANU as Annual_Leave, a.MTR as Maternity_Leave, a.ML as Marriage_Leave, a.PL as Paternity_Leave, a.HL as Hajj_Leave, a.effective_year from hrm_lv_in a where a.PBI_ID=