DBI to get the elapsed shift hours on Public Holiday

Content

Hello All,

 

I am trying to fetch the scheduled hours on Public holiday and I have tried below DBI’s and none of them are returning value.

Is there way to find out the scheduled hours on public holiday.

Shift assigned to employee is elapsed shift, hence I cannot use the EMP_START_TIME or EMP_END TIME DBI’s as well.

 

HWM_EMP_SCHD_MEASURE

HWM_PUB_SCHD_MEASURE

HWM_PUB_SCHD_ALL_MEASURE

 

Thanks and regards

Sahana